comp.databases.postgresql.general [Archive]

how to group by a joined query? (2 replies)
Prevent from Deletion (5 replies)
XA Resource Manager (0 replies)
Getting last inserted SERIAL (1 replies)
delivering database stand-alone (6 replies)
Query (2 replies)
Where is the tool to migrate a mysql db to a PostgreSQL db ? (1 replies)
[SOLVED] Socket command type E unknown (0 replies)
French translation (7 replies)
Re: More on 7.4b2 vs 7.3.4 performance (1 replies)
Field collection in trigger (0 replies)
Field collection in trigger (4 replies)
sort ignoring the, a, ... (1 replies)
Inquiry From Form [pgsql] (1 replies)
adding SERIAL to a table (2 replies)
Optimizer picks an ineffient plan (14 replies)
pgadmin3 on Gentoo (1 replies)
automatic update (1 replies)
automatic update (1 replies)
Use of oids (0 replies)
ADD_Months Function in Postgres (1 replies)
Problems with GRANTING SELECT to a table (1 replies)
LAST_DAY Function in Postgres (5 replies)
Index not being used ? (6 replies)
Re: distributed.net now runs postgresql (1 replies)
postmaster segfault with tsearch2? (1 replies)
Re: inserting via "on insert" rule (1 replies)
segfaults / backend crashing (3 replies)
absolute value fro timestamps (2 replies)
Any way to Convince postgres to push join clause inside subquery aggregate? (2 replies)
Table name lengths... (9 replies)
identifying each individual tuple locked (0 replies)
Pass parameters to a TCL function (2 replies)
setting last_value of sequence (3 replies)
Re: Restarting, ownership, and permissions (3 replies)
web hosting postgres (2 replies)
how to call a TCL function from within a plpgsql trigger? (2 replies)
Comparing dates (2 replies)
Crosstab function Problem (1 replies)
Debian Woody 7.3.4 packages? (3 replies)
Re: [HACKERS] identifying each individual tuple locked (0 replies)
pg_dump incorrect sequence value (1 replies)
Recursive Selects (1 replies)
Oracle decode Function in Postgres (4 replies)
Localization (for dates) Oracle vs. Postgresql (10 replies)
Re: Using oids (23 replies)
ERROR: PLPGSQL does not exist (1 replies)
Output from PLPGSQL (3 replies)
What is the good equivalent for ENUM ? (8 replies)
Re: Tomcat Connection Pool? (2 replies)
Re: Trunc in Postgres (5 replies)
identifying rows locked in row level locking (0 replies)
identifying rows locked in row level locking (0 replies)
syntax error in eRServer.pm line 69 (2 replies)
Access to an element of array NEW in TCL (2 replies)
is it possible to do this? have a subselect that returns two columns (6 replies)
OffsetNumber offnum (LOCKTag) (0 replies)
How many memory size takes numeric(3,0) ? (2 replies)
TCL trigger doesn't work after deleting a column (17 replies)
table constraint or trigger? (0 replies)
The following statement now fails on 7.3.4 (0 replies)
Re: postmaster crashing (8 replies)
PLPGSQL (0 replies)
descending Indexes (5 replies)
More than 1024 connections from the same c-client (0 replies)
More than 1024 connections from the same c-backend (3 replies)
Replaceing records (24 replies)
Missing system views? (1 replies)
Change connection (IP, or Databasename) (0 replies)
WHERE boolean = true -> failure (0 replies)
tsearch2 and unexpected exists (13 replies)
Activate Index (5 replies)
IP from conexion (0 replies)
postmaster processes (2 replies)
Re: NFS performance tuning (5 replies)
Re: [HACKERS] tablelevel and rowlevel locks (1 replies)
FYI: Avoiding write conflict errors in MS Access clients (0 replies)
searching archives should be a weeeee bit faster ... (4 replies)
Re: Backup? (3 replies)
Inquiry From Form [pgsql] (1 replies)
Re: [HACKERS] Decent VACUUM (was: Buglist) (0 replies)
Re: [HACKERS] Buglist (0 replies)
Seq scan of table? (6 replies)
notify problem (1 replies)
Re: [HACKERS] Question about Scripting in Postgresql. (0 replies)
Pagination - 1 or 2 queries? (10 replies)
Problem with to_date/to_char (1 replies)
Views with Where Clauses (2 replies)
default EXECUTE privilege (4 replies)
unique heritage (0 replies)
Detailed error message information (0 replies)
Left join (1 replies)
Re: How can I set postmaster as a service (3 replies)
C functions (2 replies)
aggregate function (2 replies)
Grant and wildcards (0 replies)
decrypted pwd (10 replies)
ODBC Issue (2 replies)
Re: [ADMIN] How can I set postmaster as a service (0 replies)
Needed function IF(expr, expr, expr) (9 replies)
SRF question (0 replies)
Reasonable Configuration (1 replies)
7.4 binary version (0 replies)
Inquiry From Form [pgsql] (1 replies)
Cannot createdb (3 replies)
Does "vacuum analyze" contain "vacuum"? (6 replies)
v7.4b2 : How can I use COMMENT ON for Large Objects ? (2 replies)
Unix domain instead of TCP socket connections with JDBC. (3 replies)
Code insertion (0 replies)
Can I use PostgreSQL to develop a self-organizing database system? (9 replies)
why does count take so long? (17 replies)
bolb data type (1 replies)
compiling libpq without 'main' (0 replies)
Re: plPGSQL bug in function creation (0 replies)
SRF question (3 replies)
PL/PerlU problems executing other scripts (0 replies)
inserting an apostrophe (2 replies)
Another pimple on the type system (1 replies)
Good open source mailing list system PHP / Postgresql (19 replies)
Views and Limits (2 replies)
mysql create table -> psql (7 replies)
German special characters Problem (5 replies)
Help needed in Replicating pgsql (1 replies)
ECPG bug or development choice (2 replies)
Adding header nam to any table (2 replies)
Picture with Postgres and Delphi (44 replies)
Kill -9 Postmaster and Temporary Tables (0 replies)
any chance of "like ANY (array[])" like the "= ANY (array[])" syntax? (2 replies)
encoding again (2 replies)
Oracle and regular expressions ??? (1 replies)
do child tables inherit indexes? (1 replies)
Kill -9 Postmaster and Temporary Tables (1 replies)
arbitrary data scheme (0 replies)
to_timestamp and to_date fails in postgresql 7.1.3 (1 replies)
Find overlapping time intervals, how? (6 replies)
How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ? (3 replies)
Temp tables and copy (2 replies)
State of Beta 2 (192 replies)
SUMMARY mysql -> psql (2 replies)
Constructing column from different individual fields in same row. (3 replies)
Question about conccurrency control and Insert (6 replies)
plpgsql doesn't coerce boolean expressions to boolean (0 replies)
help with TCL function (5 replies)
Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ? (0 replies)
7.4 defaulting to ipv6 ? (2 replies)
message type 0x50 (1 replies)
message type 0x50 (1 replies)
Release date (1 replies)
C API, PQconnectdb and options Q. (4 replies)
A Question About Insertions -- Performance (4 replies)
50K record DELETE Begins, 100% CPU, Never Completes 1 hour later (1 replies)
ANNOUNCE: Bricolage 1.6.5 (0 replies)
pgsql and Qt apps (0 replies)
how to replicate database (0 replies)
"another command is already in progress" error (0 replies)
PostgreSQL for AMD64 (1 replies)
how to replicate database (5 replies)
Re: MD5 function is not available ? (0 replies)
MD5() function not available ?? (0 replies)
query-question (5 replies)
Re: I need a SQL... (8 replies)
Questions about erserver (0 replies)
Create index in PG table with vb6 (2 replies)
pg 7.3.4 and linux box crash (2 replies)
How to avoid inlining subquery result columns (1 replies)
"another command is already in progress" error (fwd) (1 replies)
Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later (3 replies)
Connecting to postgres from a romote machhine (2 replies)
Function to convert (2 replies)
selecting random rows (6 replies)
library version problem, 7.3.2, php, redhat linux (7 replies)
how can i use SELECT to find a substring of a column's data? (6 replies)
Converting database-encoding from SQL_ASCII to UNICODE????? (1 replies)
Space (1 replies)
Table OraclexPostgresql (1 replies)
Between(Interval of two dates) in Postgres (1 replies)
difference when using 'distinct on' (2 replies)
Re: psql prompt (1 replies)
Re: [PORTS] plPHP for windows (1 replies)
I need examples of stored procedures returning datasets (2 replies)
Serial type currval (1 replies)
PostGreSql database features questions (2 replies)
Regarding constraint database (1 replies)
Why do I need to pass value for Serial type in Insert/Update? (2 replies)
pgSql Memory footprint (4 replies)
installation of postgres 7.3.4 rpm (0 replies)
case-insensitive database (10 replies)
New DBTools Manager 2.2.0 (0 replies)
Cyclic foreign key dependency & table inheritance (2 replies)
Re: need for in-place upgrades (was Re: State of (2 replies)
How to remove CLUSTERs and 'partitioning tables' (2 replies)
function call (2 replies)
The NT services Cygwin PostgreSQL installatio (1 replies)
is General Bits Issue # 43 correct? (0 replies)
[elein@varlena.com: Re: is General Bits Issue # 43 correct?] (0 replies)
Re: [PERFORM] best arrangement of 3 disks for (insert) performance (1 replies)
Fox Trot bows to us (2 replies)
Mirrors (1 replies)
Updates with NULL (5 replies)
Initalizing PostgreSQL Database (4 replies)
Re: encoding and parser: error? (0 replies)
after postgres upgrade - ERROR: current transaction is aborted (7 replies)
Odd behaviour -- Index scan vs. seq. scan (3 replies)
Rules question (1 replies)
Idea for improving speed of pg_restore (12 replies)
Question. (1 replies)
date_part('timezone_hour') (1 replies)
How to ALTER VARCHAR datatype to TEXT ? (0 replies)
4D to PostgreSQL tools (4 replies)
CONCAT function (12 replies)
Red Hat 9 Postgres (4 replies)
update field using substrings of another field (3 replies)
Error trigger (1 replies)
char o varchar (3 replies)
transaction abortion (0 replies)
Database Recovery Procedures (7 replies)
Problems requiring a GROUP BY clause on update? (2 replies)
backend crashing despite tsearch2 patch (2 replies)
More general datafiles ? (0 replies)
psql and blob (0 replies)
psql and blob (15 replies)
Where are PL/pgSQL functions stored? (4 replies)
Why does adding SUM and GROUP BY destroy performance? (6 replies)
Weird query plan (13 replies)
Bug while installing in AIX 5.1 (1 replies)
7.3.2 client connecting to 7.2.1 server problem (2 replies)
High-volume shop uses PostgreSQL (12 replies)
Re: [PATCHES] backend crashing despite tsearch2 patch (0 replies)
Sort order is different on Windows and Linux (2 replies)
varchar vs. text (3 replies)
Problem in Function returning Cursors - Postgres Sql 7.2 (0 replies)
Image data type equivalent in postgresql (1 replies)
Cannot Delete (5 replies)
Scalability (both vertical and horizontal)? (8 replies)
Re: Serialization, Locking...implement processing Queue with a (0 replies)
I dont know the error with updtae (0 replies)
PostgreSQL versus MySQL (38 replies)
Job Opening (0 replies)
Sequences (3 replies)
This mail list and its policies (13 replies)
About Pgdump (5 replies)
pgindented tsearch2 for 7.3.4 (0 replies)
Column defaults fail with rules on view (8 replies)
Triggers/perform oddity between 7.2 and 7.3 (1 replies)
Outer Join help please (1 replies)
adding on delete cascade constraint? (4 replies)
Zend survey result about dbms... (8 replies)
Trouble with some concepts (1 replies)
query distribution (0 replies)
DDL diff utility? (2 replies)