- Re: Storing images in PostgreSQL databases (again)
- share lock error
- how to check SQLSTATE
- Two efficiency questions - clustering and ints
- trouble with setof record return
- indexing for query speed - index row size exceeding btree maximum
- UNIQUE constraints on function results
- Re: Help required
- Generating synthetic keys on copy
- Re: now() and time zone
- now() and time zone
- [Fwd: Realizing the Value of Enterprise Open Source Databases] --May be of interest -- re Sony Online's use of Enterprise DB
- storing transactions
- Help with function
- Help required
- Storing images in PostgreSQL databases (again)
- Moving data to another disk
- Re: Fwd: Help with function
- Fwd: Help with function
- Re: Moving data to another disk
- rule for inserting into partitions
- PostgreSQL Database Transfer between machines
- Text retrieval & data mining features in PostgreSQL
- postgresql.conf shared buffers
- Hi, everyone. can i ask a question for the server side encoding GB18030 and sortorder?
- Warning during pg_dump
- Run programs within the bin folder
- Re: Potentially annoying question about date ranges (part 2)
- Foreign keys, arrays, and uniqueness
- Experiences with 3PAR
- Determining size of a database before dumping
- Re: Performance and Generic Config after install
- Re: Performance and Generic Config after install
- test
- Weird disk write load caused by PostgreSQL?
- FlushRelationBuffers Error
- Advantages of postgresql
- using float4, I get incorrect value when select
- How to trace index to table?
- PostgreSQL 8.1 - SSL:Required
- Postgres backup
- ISO week dates
- Normal vs Surrogate Primary Keys...
- String handling function, substring vs. substr
- GiST and Gin technical doc
- create table foo( ... ..., _date date default current_date, ... ...);
- Major Performance decrease after some hours
- Cause of ERROR: could not open relation 1663/856689/856777:Invalid argument?
- PostgreSQL 8.2 beta 1 on Windows Vista RC1
- Dynamic access to record columns (in PL/pgsql)
- Re: memory issues when running with mod_perl
- Backslashes in 8.2 still escape, hwo to disable?
- Re: pg web hosting with tsearch2?
- Re: [NOVICE] Do non-sequential primary keys slow performance significantly??
- pg web hosting with tsearch2?
- alter integer field to serial integer primary key
- benchmark suite
- Foreign key constraint delete fire order
- PostgreSQL 8.1.4 on Vista RC1
- 8.1.4 compile problem
- using schema's for data separation
- Re: Row versions and indexes
- Expected accuracy of planner statistics
- Re: Row versions and indexes
- contrib/levenshtein() has a bug?
- dropdb cmd line args
- Can i see server SQL commands ?
- Definition of return types for own functions?
- Full Text fuzzy search
- Strange pg_ctl behavior: postmaster shuts down on shell interrupt
- grant select on all tables of schema or database
- text to point conversion not working. ( cannot cast type text to point )
- 'pg_ctl -w' times out when unix_socket_directory is set
- memory issues when running with mod_perl
- cyclical redundancy checksum algorithm(s)?
- Cumulative aggregate
- continued segmentation fault
- strange sql issue
- dbi-link questions + patch
- Solution for rolling back many transactions?
- Postgresql reindex hangs when table is being updated
- How to create nightly backups in Linux
- Re: File System Access:
- Fulltext index in postgres?
- postgress 8.1.4 deadlocking??
- Strange query results with invalid multibyte character
- pl/pgsql NEW variable substitution
- Insert/select union bug
- Documenting stored procedures and functions
- Transaction is read-only in auto commit mode
- Sockets and posgtres
- Re: Timestamp with timezone query
- Re: change the order of FROM selection to make query work
- change the order of FROM selection to make query work
- Add serial in specific order?
- Restart after power outage: createdb
- Deadlock when one process opens two separate connections?
- cannt setup postgresql database for my opennms
- Re: Timestamp with timezone query
- deadlock avoidance
- function for longest common substring?
- Re: Timestamp with timezone query
- getting dates in the past
- pl/perl autonomous transactions question
- How to Examine a view
- Timestamp with timezone query
- Re: copy db1 to db2
- hi, what is wrong with my newbie sql?
- postgresql ddl scripts - drop object fails entire script
- query rewrite rules for updateable views?
- in failed sql transaction
- serial column
- =?us-ascii?Q?copy=20db1=20to=20db2?=
- Restart after poweroutage
- How to avoid error with convert() function
- powerset?
- Is relpages always supposed to be right?
- Re: PG_DUMP without asking password
- PG_DUMP without asking password
- how much free space in tables and index ?
- Re: Strange database corruption with PostgreSQL 7.4.x o
- Re: Backup roles / users
- Backup roles / users
- Re: Backup / export DB
- ERROR: index "patient_pkey" is not a btree
- Can i switch to the use of persistent connections with my already in use application without worrying ?
- Backup / export DB
- Re: Garbage data sent by Windows 98 client
- Backup Large Tables
- Select Cast Error
- dumping 8M bit fields
- Re: pgAdmin III v1.6 Beta 1 Released
- Character fields and length
- After Trigger
- Replication and PITR
- Re: creating table while slony-I replication is running
- execute/perform and FOUND
- Connecting to PostgreSQL Server
- Good books about PL/PGSQL programming?
- Postgres Team: Thank You All
- Re: postgresql rising
- creating table while slony-I replication is running
- Table Inheritance / VARCHAR search question
- IF EXISTS
- column names in select don't exists in insert to
- Question Regarding a Temporary Table
- Selecting from two unrelated tables
- 8.2: select from an INSERT returning?
- Problems converting between C string and Datum
- pg_dump output containing CREATE TYPE does not restore with psql
- Getting prepared statement parameters in log when using JDBC withPG 8
- Re: Strange database corruption with PostgreSQL 7.4.x o
- Re: Strange database corruption with PostgreSQL 7.4.x o
- Re: Strange database corruption with PostgreSQL 7.4.x o
- Memory efficient insertion/retrieval of bytea
- Re: Strange database corruption with PostgreSQL 7.4.x o
- Strange database corruption with PostgreSQL 7.4.x on Debian Sarge
- Clustering
- postgresql rising
- statistics buffer is full on heavily loaded 8.1.4 db.
- Re: duplicate key violates unique constraint
- Load a csv file into a pgsql table
- Re: Access to databas from the Internet
- Limits of arrays
- Access to databas from the Internet
- Re: Oracle migration : size on disk of data file greater in PG
- Oracle migration : size on disk of data file greater in PG
- vista
- duplicate key violates unique constraint
- unique key issue
- Easy Make Money Online
- Upgrading schemas
- psql memory usage when creating delimited files
- Restore data from old installation
- Restore data from old installation
- Restore data from old installation
- server resetting
- Changing schemas
- Need special sequence generator
- CLUSTERing on Insert
- What is the Best Postgresql Load Balancing Solution available ?
- FileMakerPro to postgreSQL
- Windows Vista Starter
- transaction confusion
- Re: [HACKERS] Is there any utility to update the table whenever text file gets changed?
- PostgreSQL installed in non-standard Directory
- Fwd: Multiple entries of same table in pg_class
- Re: Installation with sources or with packages
- create index in parallel?
- create table as problem
- basic geographic structure
- [OT] PHP vs Postgresql argument on Slashdot's front page.
- Migration
- Re: Installation with sources or with packages
- Installation with sources or with packages
- ECPG: non-integer constant in group by
- Re: [pgadmin-support] pgAdmin III v1.6 Beta 1 Released
- The Best Postgresql Load Balancing Solution
- Postgresql will not start when using ldap
- Re: PostgreSQL slammed by PHP creator
- Sun Java Studio Creator and PostgreSQL
- Is it possible to have multiple names for a column?
- Client Connections
- PostgreSQL slammed by PHP creator
- Optimising a query requiring seqscans=0
- When to reload and when to restart?
- Question about timestamp with time zone
- Re: remote duplicate rows
- Inherited tables vs UNION ALL views
- Running PostgreSQL in a Xen DomU?
- oracle listener intercept
- remote duplicate rows
- Kill specific connection
- Load "myLib.so" error cannot load obj file...
- Problems with date configuration
- Re: [NOVICE] Question About Aggregate Functions
- Re: [NOVICE] INSERT does not finish except if it is carried out a
- Template1 oops
- Initializing Datums for use with SPI_execute_plan
- berkley sockets
- program for graphical/schematical representation of relations between tables
- serial, sequence, and COPY FROM
- Bytea to Text problems
- Issue with order by for type varchar
- Multiple entries of same table in pg_class
- select unique items in db
- initdb: invalid locale name "sv_SE.ISO-8859-1"
- Re: Superuser lost access to particular database
- Superuser lost access to particular database
- off topic - web shop
- Need Help w/ Timestamps
- Database migration and redesign
- Groups, permissions and visibility
- Before Delete Problem - don't delet first time ?
- Re: [ANNOUNCE] == PostgreSQL Weekly News - September 10 2006 ==
- references/tutorial/tricks on dynamic generation of sql (& plpgsqlfunctions) editing/coding
- Re: Plan for outer joins
- Re: Certificate, login & php question ?
- Re: Reinstall problem of PostgreSQL in Windows XP
- Rules / Triggers and Return Row Count
- execute in pl/pgsql
- Data Warehouse
- How to use SPI_saveplan
- Is this logical?
- Idle in transaction state.
- find a free database design software
- Logging queries that are part of a stored procedure
- Reinstall problem of PostgreSQL in Windows XP
- Re: [NOVICE] Insert Only Postgresql
- Determining right size for max_fsm_pages on large setup?