Mailing lists [pgsql-sql]
- RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Mikheev, Vadim
- Library Management project Sharmad Naik
- Trigger Function and Html Output Stef Telford
- ON DELETE rule J.Fernando Moyano
- Re: Trigger Function and Html Output Richard Huxton
- Re: Trigger Function and Html Output Stef Telford
- Re: ON DELETE rule Tom Lane
- passing parameters between forms Sharmad Naik
- Re: Trigger Function and Html Output Richard Huxton
- Calling functions inside a function: behavior Edipo Elder Fernandes de Melo
- Re: passing parameters between forms Richard Huxton
- Re: Calling Java from psql (was Re: requesting help) Peter T Mount
- Error:TypeCreate: type links already defined Najm Hashmi
- Re: Calling functions inside a function: behavior Roberto Mello
- Re: Error:TypeCreate: type links already defined Richard Huxton
- Fwd: Calling functions inside a function: behavior Josh Berkus
- very very slow ..... J.Fernando Moyano
- Re: Fwd: Calling functions inside a function: behavior edipoelder@ig.com.br
- using for rec inside a function: behavior very slow Jie Liang
- select statement inside a function: behavior bad Jie Liang
- Re: using for rec inside a function: behavior very slow Tom Lane
- Re: very very slow ..... Tom Lane
- Appropriate indices to create for these queries Gerald Gutierrez
- passing null parameter to plpgsq functions Picard, Cyril
- Re: Appropriate indices to create for these queries Richard Huxton
- Re: passing null parameter to plpgsq functions Richard Huxton
- RE: passing null parameter to plpgsq functions Picard, Cyril
- Re: passing null parameter to plpgsq functions Richard Huxton
- Re: serial type; race conditions postgresql
- pg_dumpall and password access Christophe Labouisse
- Re: pg_dumpall and password access Tom Lane
- Re: Implicit/Explicit casting of the unknown type Stephen Jackson
- Re: Implicit/Explicit casting of the unknown type Josh Berkus
- Re: pg_dumpall and password access jdassen@cistron.nl (J.H.M. Dassen (Ray))
- Inserting binary data (BLOBs) in v7.1 David Lizano
- Re: pg_dumpall and password access David Lizano
- performance of functions - or rather lack of it Peter Galbavy
- Re: performance of functions - or rather lack of it Peter Galbavy
- restoring indices Koen Antonissen
- outer joins Algirdas Šakmanas
- max( bool )? Cedar Cox
- [7.0.3] optimizing a LIKE query ... The Hermit Hacker
- Re: outer joins Poet/Joshua Drake
- RE: outer joins Picard, Cyril
- Query broken under 7.1RC2 Kyle
- Re: max( bool )? Tom Lane
- Re: outer joins tjk@tksoft.com
- Strategy for unlocking query Graham Vickrage
- Re: Query broken under 7.1RC2 Tom Lane
- Historical dates in Timestamp Albert REINER
- Re: Strategy for unlocking query Tom Lane
- Re: Historical dates in Timestamp Tom Lane
- Re: performance of functions - or rather lack of it Tom Lane
- Memory and performance edipoelder@ig.com.br
- Need to do an ALTER TABLE. jkakar@expressus.com
- Memory exhaustion Srikanth Rao
- Re: Need to do an ALTER TABLE. Tom Lane
- searching for dates Birgit Jansen
- Re: searching for dates Oliver Elphick
- Re: Memory exhaustion jdassen@cistron.nl (J.H.M. Dassen (Ray))
- UNION in a VIEW? Gordon A. Runkle
- Re: max( bool )? Cedar Cox
- performance inconsistency Phuong Ma
- Re: max( bool )? Tom Lane
- Re: UNION in a VIEW? Tom Lane
- Re: Memory and performance Edipo Elder Fernandes de Melo
- Re: performance inconsistency Tom Lane
- Re: Need to do an ALTER TABLE. Josh Berkus
- Re: [7.0.3] optimizing a LIKE query ... Tom Lane
- Re: UNION in a VIEW? Josh Berkus
- Re: UNION in a VIEW? Gordon A. Runkle
- RE: RE: serial type; race conditions Gerald Gutierrez
- Re: Memory and performance Tom Lane
- [Tip] Using list-aggregates for faster batching Joel Burton
- Index on View ? Keith Gray
- Re: Memory and performance Richard Huxton
- Re: performance of functions - or rather lack of it Peter Galbavy
- Re: Index on View ? Richard Huxton
- SELECT ... FOR UPDATE Loïc Bourgeois
- Re: Memory and performance Tim Perdue
- Re: UNION in a VIEW? Gordon A. Runkle
- Project Development Kyle
- Re: Memory and performance Tom Lane
- Re: Re: UNION in a VIEW? Josh Berkus
- Re: Memory and performance Tim Perdue
- Re: Re: UNION in a VIEW? Gordon A. Runkle
- RE: RE: serial type; race conditions Jeff Eckermann
- Re: Project Development Joel Burton
- FW: RE: serial type; race conditions Jeff Eckermann
- please help Loïc Bourgeois
- Double-nesting quotes? Josh Berkus
- Re: please help Peter Eisentraut
- Re: Index on View ? Keith Gray
- Re: very very slow ..... J.Fernando Moyano
- get all online user? guard
- Re: please help Loïc Bourgeois
- Re: Index on View ? Richard Huxton
- how to do this join ? juerg.rietmann@pup.ch
- Re: how to do this join ? Peter Eisentraut
- Re: how to do this join ? Tom Lane
- Does pg_dump stable on v7.0 Jie Liang
- "row_count" reserved? Josh Berkus
- Re: "row_count" reserved? Tom Lane
- Memory And Performance Mark Kirkwood
- Update Kyle
- 7.1 grant/revoke speed Kyle
- Need help with EXECUTE function Josh Berkus
- Casting numeric to text Hans-Jürgen Schönig
- Sql error comp
- Aliasing on tables ... Hans-Jürgen Schönig
- pg_dump and oid Richard
- Re: Index on View ? Ian Harding
- Re: UNION in a VIEW? Gordon A. Runkle
- help Loïc Bourgeois
- Can anyone explain how this works? RbrtBrn3@aol.com
- Re: Trigger Function and Html Output Christopher Masto
- Re: Maybe a Bug, maybe bad SQL Louis-David Mitterrand
- Re: Can anyone explain how this works? Joel Burton
- Re: Casting numeric to text Peter Eisentraut
- Re: [GENERAL] Re: Permissons on database Louis-David Mitterrand
- open and closed paths ... Hans-Jürgen Schönig
- Re: open and closed paths ... Peter Eisentraut
- Re: Casting numeric to text Cedar Cox
- Re: Need help with EXECUTE function Cedar Cox
- Re: Double-nesting quotes? Cedar Cox
- Re: please help Cedar Cox
- Re: open and closed paths ... Hans-Jürgen Schönig
- create function Tomáš Nohejl
- Re: Casting numeric to text Peter Eisentraut
- Re: please help Peter Eisentraut
- Re: Casting numeric to text Ross J. Reedstrom
- Re: Re: open and closed paths ... Peter Eisentraut
- Re: Casting numeric to text Peter Eisentraut
- Re: select substr??? Tim Johnson
- Re: Casting numeric to text Ross J. Reedstrom
- pg_dump and BLOB Richard
- Re: Re: select substr??? Peter Eisentraut
- Sorting and then... Wei Weng
- Inheritance Semantics Mark Butler
- Re: Sorting and then... Roberto Mello
- Re: Inheritance Semantics Bruce Momjian
- RE: Sorting and then... Michael Ansley
- Copying null values Amanda Riera
- The Momjian Tome / DBA Certification Thomas Good
- Re: Copying null values Christof Glaser
- Re: problem with copy command Joel Burton
- \i command Najm Hashmi
- Re: Sorting and then... Jason Earl
- Semantics of Typed Numeric Constants Mark Butler
- Re: \i command Joel Burton
- Re: Re: \i command Joel Burton
- a select statement that sometimes joins Mark Stosberg
- Re: Re: \i command Najm Hashmi
- Re: Re: select substr??? Albert REINER
- Re: a select statement that sometimes joins Oliver Elphick
- RE: Re: select substr??? Jeff Eckermann
- RE: Re: select substr??? Jeff Eckermann
- Re: [GENERAL] install pgSQL 7.1 datactrl
- Foreign Key between different databases Stan van de Mortel
- problem with copy command Jaruwan Laongmal
- Re: Foreign Key between different databases Cedar Cox
- Re: problem with copy command George Moga
- Concatenate fields Amanda Riera
- Re: problem with copy command Oliver Elphick
- Re: Concatenate fields Oliver Elphick
- enumerating rows Kovacs Zoltan
- Re: enumerating rows Poul L. Christiansen
- Re: Re: \i command cbell
- Re: enumerating rows Kovacs Zoltan
- RE: enumerating rows Koen Antonissen
- Re: enumerating rows Oliver Elphick
- Re: enumerating rows Kovacs Zoltan
- Making SELECT COUNT(seed) FROM fast Gerald Gutierrez
- Re: Making SELECT COUNT(seed) FROM fast Peter Eisentraut
- Re: enumerating rows Josh Berkus
- Re: enumerating rows Oliver Elphick
- Re: enumerating rows Joel Burton
- DB porting questions... Diehl, Jeffrey
- RE: DB porting questions... Michael Ansley
- Re: DB porting questions... Josh Berkus
- Re: DB porting questions... Joel Burton
- Timezone conversion Roberto Mello
- Calling plSQL functions Lonnie Cumberland
- Re: Calling plSQL functions Josh Berkus
- Re: Calling plSQL functions Lonnie Cumberland
- Re: Calling plSQL functions Lonnie Cumberland
- Re: Calling plSQL functions Josh Berkus
- Re: RE: Re: select substr??? Albert REINER
- Full outer join Tim Perdue
- Function overlaps_interval Josh Berkus
- Triggers on SELECT Lonnie Cumberland
- RE: DB porting questions... Diehl, Jeffrey
- DROP TABLE in transaction David Olbersen
- RE: DB porting questions... Diehl, Jeffrey
- Re: Function overlaps_interval Roberto Mello
- Re: Triggers on SELECT Joel Burton
- RE: RE: Re: select substr??? Jeff Eckermann
- Re: DROP TABLE in transaction Peter Eisentraut
- Re: DROP TABLE in transaction David Olbersen
- Re: DROP TABLE in transaction Joel Burton
- Re: enumerating rows Peter Eisentraut
- Re: Update Tom Lane
- Re: Sql error Tom Lane
- Re: Full outer join Tom Lane
- Re: Full outer join Tim Perdue
- Re: Update Kyle
- Debian Package problems Roberto Mello
- Re: Debian Package problems Roberto Mello
- Re: Full outer join Tom Lane
- Re: Full outer join Tim Perdue
- Re: Full outer join Tom Lane
- Re: Debian Package problems Oliver Elphick
- Re: 7.1 grant/revoke speed Tom Lane
- Re: Debian Package problems Roberto Mello
- BOOLEAN data type? Josh Berkus
- Re: BOOLEAN data type? Peter Eisentraut
- Mailing list gripes (was Re: Re: Maybe a Bug, maybe bad SQL) Tom Lane
- Re: RE: RE: Re: select substr??? Tom Lane
- Re: Calling plSQL functions Tom Lane
- Re: Calling plSQL functions Lonnie Cumberland
- Re: Calling plSQL functions Tom Lane
- Re: Calling plSQL functions Josh Berkus
- Re: Calling plSQL functions Lonnie Cumberland
- bound variables with PHP? Phil Glatz
- Bug in user management? Hans-Jürgen Schönig
- Dropping users with no name Hans-Jürgen Schönig
- Savepoints Hans-Jürgen Schönig
- Re: enumerating rows Luis C. Ferreira
- SELECT query Sharmad Naik
- Problem in writing functions Kris
- Re: Savepoints Bruce Momjian
- Re: Bug in user management? Tom Lane
- Re: Problem in writing functions Josh Berkus
- nobody user can't nextval('phone_id_seq') Ian Pulsford
- Re: nobody user can't nextval('phone_id_seq') Tod McQuillin
- Re: enumerating rows Kovacs Zoltan
- Re: Dropping users with no name Oliver Elphick
- Re: BOOLEAN data type? Tom Lane
- Re: Bug in user management? Cedar Cox
- Simple Question Lonnie Cumberland
- Re: BOOLEAN data type? Josh Berkus
- Re: BOOLEAN data type? Josh Berkus
- g++ not working for postgresql extension languages? Lonnie Cumberland
- Re: Full outer join Tom Lane
- Same question about PostgreSql Sergey E. Volkov
- Re: Same question about PostgreSql Poet/Joshua Drake
- How to store gif or jpeg? Thanks! Maurizio Ortolan
- How to simulate MEMO data type?Thanks! Maurizio Ortolan
- RTREE on points Julian Scarfe
- Re: How to simulate MEMO data type?Thanks! Mitch Vincent
- Re: How to simulate MEMO data type?Thanks! Christof Glaser
- Re: [GENERAL] How to store gif or jpeg? Thanks! Nelson Ferreira Jr
- Re: [GENERAL] How to simulate MEMO data type?Thanks! Yann Ramin
- Re: Same question about PostgreSql Josh Berkus
- DBD and DBI::Pg N@ta$
- Re: DBD and DBI::Pg Joel Burton
- RE: DBD and DBI::Pg Sterin, Ilya
- Re: Same question about PostgreSql Johannes Grødem
- Using Random Sequence as Key Bernardo de Barros Franco
- Re: Using Random Sequence as Key Peter Eisentraut
- Re: RTREE on points Jeff Hoffmann
- Re: Using Random Sequence as Key Peter Eisentraut
- Range of Serial values cbell
- Re: Range of Serial values Poul L. Christiansen
- RULE ... TO table.column Albert REINER
- Re: Using Random Sequence as Key Roberto Mello
- Re: Range of Serial values Justin Clift
- Re: Range of Serial values cbell
- Using Random Sequence as Key Dan Lyke
- Re: RTREE on points Jeff Hoffmann
- Re: RTREE on points Tom Lane
- Re: Using Random Sequence as Key Bernardo de Barros Franco
- Re: Using Random Sequence as Key Bernardo de Barros Franco
- Re: Using Random Sequence as Key Bernardo de Barros Franco
- Cursors in plpgsql Preeti Kamble
- Re: RTREE on points Julian Scarfe
- function to format floats as money? Mark Stosberg
- drastic reduction in speed of inserts as the table grows Rini Dutta
- Re: function to format floats as money? Peter Eisentraut
- Re: Re: Using Random Sequence as Key Josh Berkus
- Re: Cursors in plpgsql Josh Berkus
- Re: [GENERAL] drastic reduction in speed of inserts as the table grows Rini Dutta
- Re: function to format floats as money? Mark Stosberg
- Re: [GENERAL] drastic reduction in speed of inserts as the table grows Tom Lane
- Re: RTREE on points Jeff Hoffmann
- Another qs Re: [GENERAL] drastic reduction in speed of inserts as the table grows Rini Dutta
- Re: [GENERAL] drastic reduction in speed of inserts as the table grows Tom Lane
- Re: RTREE on points Jeff Hoffmann
- Re: RTREE on points Tom Lane
- Re: function to format floats as money? Ross J. Reedstrom
- Re: RTREE on points Tom Lane
- any proper benchmark scripts? clayton cottingham
- Re: function to format floats as money? John Hasler
- is this proper sql? clayton cottingham
- Re: RTREE on points Oleg Bartunov
- Re: function to format floats as money? Ross J. Reedstrom
- Re: is this proper sql? Stephan Szabo
- Re: is this proper sql? David Olbersen
- Re: function to format floats as money? John Hasler
- Re: is this proper sql? Tom Lane
- Re: RTREE on points Jeff Hoffmann
- Re: is this proper sql? Peter Eisentraut
- Re: RTREE on points Oleg Bartunov
- Problems w/ PL/pgSQL not being loaded? Diehl, Jeffrey
- Re: Problems w/ PL/pgSQL not being loaded? Philip Hallstrom
- RE: Problems w/ PL/pgSQL not being loaded? Diehl, Jeffrey
- Where are the 7.1 RPM's? Lonnie Cumberland
- Re: DB porting questions... Vivek Khera
- Re: Same question about PostgreSql Nils Zonneveld
- Re: Re: Using Random Sequence as Key Brook Milligan
- Re: Where are the 7.1 RPM's? clayton
- Re: Re: DB porting questions... Roberto Mello
- Re: Where are the 7.1 RPM's? Roberto Mello
- Re: Where are the 7.1 RPM's? Mike Castle
- Re: Re: Same question about PostgreSql Josh Berkus
- Re: Concatenate fields Amanda Riera
- maybe Offtopic : PostgreSQL & PHP ? Picard, Cyril
- Subqueries in select clause Sara Cohen
- Re: maybe Offtopic : PostgreSQL & PHP ? Keith Wong
- Re: maybe Offtopic : PostgreSQL & PHP ? Roberto Mello
- Re: Subqueries in select clause Tom Lane
- Re: Subqueries in select clause Stephan Szabo
- Re: Subqueries in select clause Richard Huxton
- Re: maybe Offtopic : PostgreSQL & PHP ? Roberto Mello
- Re: maybe Offtopic : PostgreSQL & PHP ? Josh Berkus
- Re: Subqueries in select clause Josh Berkus
- Re: maybe Offtopic : PostgreSQL & PHP ? Mathijs Brands
- Re: Subqueries in select clause Tom Lane
- RE: Re: DB porting questions... Diehl, Jeffrey
- breakage in schema with foreign keys between 7.0.3 and 7.1 Stef Telford
- Re: RTREE on points Oleg Bartunov
- Re: RTREE on pointsy Bruce Momjian
- Re: breakage in schema with foreign keys between 7.0.3 and 7.1 Stephan Szabo
- Re: breakage in schema with foreign keys between 7.0.3 and 7.1 Stef Telford
- RE: Re: DB porting questions... Diehl, Jeffrey
- groups in postgres Martín Marqués
- RE: Re: DB porting questions... Michael Fork
- Re: Timezone conversion Grant
- Re: any proper benchmark scripts? Clayton Cottingham aka drfrog
- Re: groups in postgres Richard Huxton
- Re: any proper benchmark scripts? Justin Clift
- Re: groups in postgres Martín Marqués
- windows version Padmajha Raghunaathan
- Re: any proper benchmark scripts? Thomas Good
- Postgres book Mateusz Mazur
- copy into serial field with auto_increment Andy
- Re: [GENERAL] Where are the 7.1 RPM's? Lamar Owen
- Postgresql to Access Mateusz Mazur
- Re: any proper benchmark scripts? clayton cottingham
- Re: any proper benchmark scripts? Roberto Mello
- Re: Postgresql to Access Poul L. Christiansen
- Re: any proper benchmark scripts? clayton cottingham
- Re: Postgresql to Access Roberto Mello
- Re: Postgresql to Access Joel Burton
- Re: function to format floats as money? (removing space padding) Mark Stosberg
- Re: copy into serial field with auto_increment Oliver Elphick
- Re: function to format floats as money? (removing space padding) Karel Zak
- Re: How to store gif or jpeg? Thanks! Peter T Mount
- Thank you Mateusz Mazur
- Client/Server Security question Lonnie Cumberland
- Re: Client/Server Security question Mark Stosberg
- select ... for update in plpgsql Jie Liang
- creating tables that are visible across databases Mark Stosberg
- Re: creating tables that are visible across databases Tom Lane
- Re: creating tables that are visible across databases Jeff Hoffmann
- plpgsql Jie Liang
- Re: plpgsql Roberto Mello
- PSQL 7.1 DEBS Mateusz Mazur
- Re: PSQL 7.1 DEBS Oliver Elphick
- Re: Cursors in plpgsql Hans-Jürgen Schönig
- Re: windows version Hans-Jürgen Schönig
- HELP : Can't load JDBC driver ! nusa
- Re: plpgsql Jie Liang
- Re: [GENERAL] Client/Server Security question Matthew Hixson
- Re: HELP : Can't load JDBC driver ! Josh Berkus
- Re: Re: Cursors in plpgsql Richard Huxton
- pg_dump bug? (7.1) Cedar Cox
- Problems handling errors in PL/pgSQL Josh Berkus
- Re: Problems handling errors in PL/pgSQL Joe Conway
- Re: Problems handling errors in PL/pgSQL Josh Berkus
- Re: pg_dump bug? (7.1) Tom Lane
- Re: Problems handling errors in PL/pgSQL Tom Lane
- Re: Problems handling errors in PL/pgSQL Tom Lane
- Re: Problems handling errors in PL/pgSQL Josh Berkus
- Re: Problems handling errors in PL/pgSQL Josh Berkus
- using top-level aggregate values in subqueries Thomas F. O'Connell
- Re: using top-level aggregate values in subqueries Tom Lane
- Re: select ... for update in plpgsql Cedar Cox
- Re: Timezone conversion Cedar Cox
- RE: Timezone conversion Francis Solomon
- Table corrupted and data lost (second time in one month!!) J.Fernando Moyano
- Re: Table corrupted and data lost (second time in one month!!) Josh Berkus
- RE:Table corrupted and data lost (second time in one month!!) Mark Kirkwood
- Re: RE:Table corrupted and data lost (second time in one month!!) Antti Linno
- MySql 'REPLACE' Alessio Bragadini
- Re: MySql 'REPLACE' Thomas Good
- Re: MySql 'REPLACE' Alessio Bragadini
- Re: Table corrupted and data lost (second time in one month!!) Tom Lane
- RI permission problem Kyle
- Re: RI permission problem Peter Eisentraut
- use of arrow keys to traverse history Peter J. Schoenster
- Re: use of arrow keys to traverse history Andrew Perrin
- Re: use of arrow keys to traverse history Dorin Grunberg
- Re: RI permission problem Kyle
- Error explaination? Josh Berkus
- Re: RI permission problem Stephan Szabo
- problems with pl/pgsql Mark Nielsen
- RE: MySql 'REPLACE' Diehl, Jeffrey
- Re: RI permission problem Peter Eisentraut
- Re: Error explaination? Jan Wieck
- Re: Error explaination? Josh Berkus
- Re: use of arrow keys to traverse history Grant
- Re: use of arrow keys to traverse history Martín Marqués
- Re: use of arrow keys to traverse history Grant
- must I create the function check_primary_key ? Peter J. Schoenster
- Re: must I create the function check_primary_key ? Stephan Szabo
- Regexps -- too complex? Emils Klotins
- Re: Using Random Sequence as Key Vasilis Samoladas
- Re: using top-level aggregate values in subqueries Ossie J. H. Moore
- Re: MySql 'REPLACE' Thomas Swan
- problem with pl/pgsql Mark Nielsen
- SET SEQSCAN TO OFF - error Hans-Jürgen Schönig
- simulate union in subselect Wei Weng
- Re: Regexps -- too complex? Emils Klotins
- realising a counter in an pgpsql-trigger chris Günther
- Re: SET SEQSCAN TO OFF - error Peter Eisentraut
- Re: SET SEQSCAN TO OFF - error Bruce Momjian
- Re: SET SEQSCAN TO OFF - error Jeff Hoffmann
- Re: Regexps -- too complex? Tom Lane
- Re: problem with pl/pgsql Josh Berkus
- Re: simulate union in subselect Peter Eisentraut
- Re: simulate union in subselect Tom Lane
- Re: realising a counter in an pgpsql-trigger Kenn Thompson
- No JOINs in UPDATE ... FROM? Josh Berkus
- random rows Jie Liang
- Re: random rows Joao Pedro M. F. Monoo
- Re: random rows Josh Berkus
- Re: random rows Joel Burton
- Re: use of arrow keys to traverse history Martín Marqués
- Re: random rows jdassen@cistron.nl (J.H.M. Dassen (Ray))
- rules Martín Marqués
- Re: rules Joel Burton
- Re: rules Jan Wieck
- Re: No JOINs in UPDATE ... FROM? Tom Lane
- Re: MySql 'REPLACE' Vivek Khera
- Re: must I create the function check_primary_key ? Peter J. Schoenster
- Regular expressions and indexes Hans-Jürgen Schönig
- Using Transaction Blocks w/ SELECT
- Re: Using Transaction Blocks w/ SELECT Peter Eisentraut
- Re: Regular expressions and indexes Stephan Szabo
- Alter Table problems Scott David Walter
- anyone use contrib/rserv? clayton cottingham
- Re: Alter Table problems Stephan Szabo
- Heres a good one... Steve Meynell
- order of multiple assignments in UPDATE Anuradha Ratnaweera
- Re: Heres a good one... Anuradha Ratnaweera
- Re: HELP : Can't load JDBC driver ! Peter Mount
- Re: order of multiple assignments in UPDATE Ossie J. H. Moore
- Re: Heres a good one... Steve Meynell
- views and rules on update Martín Marqués