Home > mailing lists

Mailing lists [pgsql-novice]

1 May 2005

14:15 CONSTRAINT ... FOREIGN KEY tövis
16:24 psql: Is it possible to run a query from a *sql file? Ennio-Sr
17:24 Re: psql: Is it possible to run a query from a *sql file? Tom Lane
18:33 how to make collation work Havasvölgyi Ottó
19:23 Re: how to make collation work tövis
20:29 Re: how to make collation work Volkan YAZICI
23:30 Re: psql: Is it possible to run a query from a *sql file? Ennio-Sr

2 May 2005

00:30 Re: psql: Is it possible to run a query from a *sql file? Ennio-Sr
01:01 psql: Is it possible to run a query from a *sql file? Ennio-Sr
13:03 Connection problems with "psql -h localhost postgres" Wayne Pierce
13:34 Re: psql: Is it possible to run a query from a *sql file? Bruno Wolff III
13:39 Re: [despammed] Connection problems with "psql -h localhost postgres" Andreas Kretschmer
13:39 Re: how to make collation work Bruno Wolff III
14:06 Re: [despammed] Connection problems with "psql -h localhost postgres" Wayne Pierce
15:17 Re: Connection problems with "psql -h localhost postgres" Tom Lane
16:03 Re: Connection problems with "psql -h localhost postgres" Ennio-Sr
16:19 Re: how to make collation work Havasvölgyi Ottó
16:37 Re: how to make collation work tövis
17:43 Re: Problem with DirectFunctionCall3(array_in,...) Jessica Ditt
18:41 Foreign Key Problem
20:30 Purpose of pgsql/data/global directory? - permissions error DavidF@nhb.org
21:01 Re: how to make collation work Havasvölgyi Ottó
21:09 OIDs Keith Worthington
21:15 Re: how to make collation work Havasvölgyi Ottó
21:20 Re: OIDs Frank Bax
21:27 Re: OIDs Terry Lee Tucker
22:17 psql not warning while creating a wrong function? Ennio-Sr

3 May 2005

02:19 Re: Foreign Key Problem Tom Lane
02:24 Re: Foreign Key Problem
02:30 Re: CONSTRAINT ... FOREIGN KEY
02:31 Re: Purpose of pgsql/data/global directory? - permissions error Tom Lane
03:10 Re: Foreign Key Problem Tom Lane
04:43 Re: Foreign Key Problem
09:50 Re: CONSTRAINT ... FOREIGN KEY tövis
09:58 KEY or INDEX tövis
10:42 Re: CONSTRAINT ... FOREIGN KEY Sean Davis
12:04 Re: CONSTRAINT ... FOREIGN KEY tövis
12:08 Re: CONSTRAINT ... FOREIGN KEY Sean Davis
14:29 Re: query like this??? Akbar
15:48 Re: Purpose of pgsql/data/global directory? - permission DavidF@nhb.org
17:18 Can't Use DB As Template - accessed by other users error
18:47 Re: Can't Use DB As Template - accessed by other users error tgoodaire@linux.ca (Tim Goodaire)
19:35 Re: Can't Use DB As Template - accessed by other users error
19:44 Re: Foreign Key Problem
20:09 Re: KEY or INDEX Bruno Wolff III
20:12 retrieving a previously defined stored procedure from the database? Celia McInnis
20:17 Re: Can't Use DB As Template - accessed by other users error Volkan YAZICI
20:43 Re: retrieving a previously defined stored procedure from the database? Tom Lane
21:09 drop if exists Celia McInnis
21:21 comparison trigger function Keith Worthington

4 May 2005

13:42 Re: Can't Use DB As Template - accessed by other users error Andrew Hammond
13:56 Re: comparison trigger function Andrew Hammond
15:33 Output of PL/PGSQL? David
16:12 Cascade Delete To Override Table Restrict Delete
16:21 Re: Last ID Problem
16:36 Re: Last ID Problem Bruno Wolff III
18:58 date update check sZEJTAN
19:12 Re: date update check Bruno Wolff III
19:15 Re: Output of PL/PGSQL? John DeSoi
20:44 date interval Keith Worthington
23:12 Re: date interval Frank Bax
23:18 Re: date interval Frank Bax
23:34 Re: connect from perl: error in Carp.pm Greg Sabino Mullane

5 May 2005

12:36 function returning record Roberto Rezende de Assis
13:12 ERROR: relation "mytable" does not exist Peter Schonefeld
13:31 Re: ERROR: relation "mytable" does not exist John DeSoi
14:12 Re: function returning record Tom Lane
14:39 Re: date interval Keith Worthington
15:00 Re: function returning record Sean Davis
15:19 Re: date interval Keith Worthington
19:53 Execute function without execute privilege Walker, Jed S
20:24 Re: Execute function without execute privilege Tom Lane

6 May 2005

01:18 downloading files Cima
11:26 Re: downloading files Volkan YAZICI
13:18 cursor problem Vidya
13:33 Re: cursor problem Michael Fuhr
14:46 Re: Execute function without execute privilege Walker, Jed S
15:28 Re: Execute function without execute privilege Walker, Jed S
15:42 Re: Execute function without execute privilege Bruno Wolff III
15:43 Re: Execute function without execute privilege Tom Lane
15:59 Re: connect from perl: error in Carp.pm Brad Nicholson
19:45 returned row number Keith Worthington
20:40 Re: returned row number Bruno Wolff III
21:00 Re: returned row number Keith Worthington

7 May 2005

00:24 Re: returned row number Celia McInnis
00:39 convert from epoch to timestamp Celia McInnis

9 May 2005

15:45 downloading files- more details Cima
17:33 Re: downloading files- more details William Yu
20:41 Re: convert from epoch to timestamp Bruno Wolff III
20:43 Re: returned row number Bruno Wolff III

11 May 2005

02:44 Trigger Prasad dev
13:15 Select dump SG Edwards
13:33 Re: [despammed] Select dump Andreas Kretschmer
13:49 Re: [despammed] Select dump John DeSoi
13:53 First plpgsql Script Van Ingen, Lane
13:59 Re: Select dump Geoffrey
14:05 Re: First plpgsql Script Tom Lane

12 May 2005

05:37 Using PgSQL in high volume and throughput problem Nikola Milutinovic
07:31 Autocommit in Postgresql Vitaly Belman
08:15 Re: Autocommit in Postgresql Olivier Thauvin
10:47 Trigger Procedures Steve Tucknott
13:26 Re: Autocommit in Postgresql Vitaly Belman
13:43 Starting the Database Vyom A
14:43 Re: Autocommit in Postgresql Tom Lane
17:48 syncing a serial across tables Keith Worthington
18:02 Re: syncing a serial across tables Volkan YAZICI
18:16 Re: syncing a serial across tables Bruno Wolff III
19:30 Re: Using PgSQL in high volume and throughput problem Josh Berkus
19:31 Re: Trigger Procedures Josh Berkus
20:05 how to copy data between machines ? D.C.
20:10 Re: how to copy data between machines ? D.C.
20:11 Re: how to copy data between machines ? Mark Greenbank
20:17 Re: how to copy data between machines ? D.C.
20:19 Re: how to copy data between machines ? Tom Lane
20:22 Re: how to copy data between machines ? Frank Bax
20:33 Re: how to copy data between machines ? D.C.
20:38 Re: how to copy data between machines ? Tom Lane
20:48 Re: how to copy data between machines ? Peter Bierman
20:54 Re: how to copy data between machines ? D.C.

13 May 2005

05:27 Re: Starting the Database Vyom A
06:41 [Fwd: Re: Trigger Procedures] Steve Tucknott
12:38 problems with postgresql.msi (installing 8.0.2)
12:53 Re: Starting the Database John DeSoi
14:20 Re: [Fwd: Re: Trigger Procedures] Stephan Szabo
18:27 nope, still no history .. D.C.
18:52 Re: nope, still no history .. D.C.

14 May 2005

09:36 Re: Starting the Database Vyom A
10:45 Can null values be sorted low? ann hedley
11:56 Re: Starting the Database John DeSoi
15:24 Re: Can null values be sorted low? Jeff Eckermann

15 May 2005

00:04 [Win2k - Version 8.0.2] - StartupMessage Format Question Tom Pfeifer
01:04 Re: [Win2k - Version 8.0.2] - StartupMessage Format Question Olivier Thauvin
01:47 Re: [Win2k - Version 8.0.2] - StartupMessage Format Question John DeSoi
02:16 Re: [Win2k - Version 8.0.2] - StartupMessage Format Question Tom Pfeifer
03:19 Re: [Win2k - Version 8.0.2] - StartupMessage Format Question John DeSoi
15:59 Fw: Re: [Win2k - Version 8.0.2] - StartupMessage Format Question Tom Pfeifer
17:51 Re: Fw: Re: [Win2k - Version 8.0.2] - StartupMessage Format Question Volkan YAZICI
18:00 ...
18:00 Cron /usr/libexec/save-entropy operator@zeus.cablerocket.net (Cron Daemon)
18:00 ...

16 May 2005

07:17 concepts? D.C.
08:37 Re: Can null values be sorted low? ann hedley
11:12 Re: Starting the Database Vyom A
15:03 Re: problems with postgresql.msi (installing 8.0.2)
15:28 Re: problems with postgresql.msi (installing 8.0.2)
15:38 Re: concepts?
15:42 COPY from stdin; Peter Schonefeld
16:50 describe table (from perl) Celia McInnis
17:08 Re: concepts? Andres Ledesma
17:21 Re: COPY from stdin; John DeSoi
17:38 Re: concepts? Tom Lane
17:38 Re: concepts? Stephan Szabo
18:23 Problem with Out-of-resources error? cbrazvan@laitek.com
18:55 Re: Problem with Out-of-resources error? tgoodaire@linux.ca (Tim Goodaire)
19:09 Re: Problem with Out-of-resources error? Razvan Costea-Barlutiu
19:20 Re: Problem with Out-of-resources error? Buddy Shearer
19:30 Re: Problem with Out-of-resources error? tgoodaire@linux.ca (Tim Goodaire)
20:32 Re: Problem with Out-of-resources error? D.C.
20:55 Writing First Trigger Function in PostgreSQL Van Ingen, Lane
21:23 Re: Writing First Trigger Function in PostgreSQL Sean Davis
23:00 Re: describe table (from perl) Greg Sabino Mullane

17 May 2005

04:15 Re: problems with postgresql.msi (installing 8.0.2)
04:46 Re: Problem with Out-of-resources error? Razvan Costea-Barlutiu
08:48 Re: concepts? D.C.
14:51 BAD SU operator at Postgresql startup (during boot) Hal Shearer
15:46 Re: BAD SU operator at Postgresql startup (during boot) Tom Lane
15:48 Median/Quantile Aggregate David Orme
16:17 Re: Median/Quantile Aggregate Sean Davis
16:34 Re: Median/Quantile Aggregate Tom Lane
16:38 Re: Median/Quantile Aggregate Adam Witney
16:46 Re: Median/Quantile Aggregate David Orme
16:47 Re: concepts?
16:50 Re: [JDBC] Using PgSQL in high volume and throughput problem Scott Marlowe
16:53 Help: Input Error Notice McCormick, Bill
16:58 BAD SU operator at startup Buddy Shearer
16:58 Re: problems with postgresql.msi (installing 8.0.2) Magnus Hagander
16:59 Re: BAD SU operator at Postgresql startup (during boot) Buddy Shearer
17:00 Unable to connect from other machine Mikko Heiskanen
17:01 BAD SU operator at Postgresql startup (during boot) Buddy Shearer
17:01 Re: problems with postgresql.msi (installing 8.0.2) Magnus Hagander
17:02 Problem with functions Wersinger, Jürgen
17:03 Re: problems with postgresql.msi (installing 8.0.2) Magnus Hagander
17:09 Re: Median/Quantile Aggregate David Orme
17:12 Re: problems with postgresql.msi (installing 8.0.2)
17:40 Re: Help: Input Error Notice Tom Lane
17:52 Re: problems with postgresql.msi (installing 8.0.2) John DeSoi
18:21 ERROR: DROP TABLE is not allowed in a non-volatile function Alan T. Miller
18:46 Re: ERROR: DROP TABLE is not allowed in a non-volatile function Keith Worthington
18:56 cluster-operation successfull? Timo Roessner
19:42 Re: cluster-operation successfull? Tom Lane

18 May 2005

10:41 Storing/Using Passwords William Shatner
11:51 Re: Storing/Using Passwords Sean Davis
11:56 Re: cluster-operation successfull? Timo Roessner
12:58 Psql bug on Windows or pilot error? ;-) Schuhmacher, Bret
13:02 Re: Storing/Using Passwords Pascual De Ruvo
14:30 Re: Psql bug on Windows or pilot error? ;-) John DeSoi
16:12 Re: Unable to connect from other machine tgoodaire@linux.ca (Tim Goodaire)
22:23 database conversion to postgres Jeff Dyke

19 May 2005

05:16 How to check tablespace Low Kian Seong
05:29 Re: How to check tablespace Tom Lane
05:40 Re: How to check tablespace Low Kian Seong
15:01 Re: database conversion to postgres Keith Worthington
15:27 Re: database conversion to postgres Sean Davis
15:36 Revision Data Type
18:42 Trigger Function Problem Van Ingen, Lane
18:44 How to deal with large object? Pierre Couderc
19:30 Timezone into/out of function Walker, Jed S
21:48 Re: Trigger Function Problem Tom Lane
21:52 Re: Timezone into/out of function Tom Lane

20 May 2005

20:37 datatype conversion on postgresql 7.4.1 Timo Roessner

21 May 2005

10:06 postgresql-dump .. catch 22 ? Adam Bogacki
12:08 REFERENCES to foreign tables D.C.
12:27 Re: REFERENCES to foreign tables John DeSoi
12:35 Re: REFERENCES to foreign tables Michael Glaesemann
14:45 Re: postgresql-dump .. catch 22 ? Tom Lane
18:20 Re: REFERENCES to foreign tables D.C.

22 May 2005

04:20 Fixing postmaster (7.2->7.4.8) Adam Bogacki
07:52 references again D.C.
08:31 Re: references again Michael Glaesemann

23 May 2005

01:36 postgres file Ramon Orticio
06:22 Re: postgres file Volkan YAZICI
06:35 Re: postgres file Aarni Ruuhimäki
09:04 Problem restarting server Agustín Caminero Herráez
09:17 postgres files in windows xp Ramon Orticio
13:23 Re: Problem restarting server Tom Lane
13:57 Re: postgres files in windows xp Aarni Ruuhimäki
14:16 Re: Problem restarting server Agustín Caminero Herráez
14:17 Re: postgres files in windows xp Afton & Ray Still
15:51 Help with prepared statement Bendik Rognlien Johansen
17:53 Re: Problem restarting server Bruno Wolff III
18:19 Re: postgres files in windows xp
21:10 "NOT NULL" field tövis
21:16 Re: "NOT NULL" field Jaime Casanova
21:33 "NOT NULL" tövis
22:09 more "NOT NULL" tövis
22:12 Re: "NOT NULL" field tövis

24 May 2005

01:02 Re: "NOT NULL" field Jaime Casanova
05:08 Re: [despammed] more "NOT NULL" Andreas Kretschmer
05:13 Re: [despammed] "NOT NULL" Andreas Kretschmer
05:28 Re: "NOT NULL" Jaime Casanova
06:40 Re: "NOT NULL" tövis
07:21 Re: Help with prepared statement Bendik Rognlien Johansen
07:48 A question about postmaster and postgresql commands Agustín Caminero Herráez
08:00 Re: [despammed] A question about postmaster and postgresql commands Andreas Kretschmer
08:45 Re: "NOT NULL" Jan B.
08:48 Trigger unhappy Bendik Rognlien Johansen
08:54 Trigger unhappy (Correction) Bendik Rognlien Johansen
09:02 Re: [despammed] Trigger unhappy Andreas Kretschmer
09:08 Re: "NOT NULL" tövis
10:39 Re: "NOT NULL" tövis
10:53 Re: "NOT NULL" Jan B.
12:34 Re: [despammed] Trigger unhappy Bendik Rognlien Johansen
12:41 Re: "NOT NULL" tövis
15:58 Sparse Data Walker, Jed S
16:08 Re: Trigger unhappy (Correction) Miguel que te importa
17:13 Re: Sparse Data Tom Lane
17:21 Re: "NOT NULL" Bruno Wolff III
18:02 UPDATE with JOIN Keith Worthington
18:26 Re: UPDATE with JOIN Tom Lane
18:43 Re: Sparse Data Walker, Jed S
19:28 Re: Trigger unhappy (Correction) Jeff Eckermann
20:31 Re: UPDATE with JOIN Keith Worthington

25 May 2005

00:48 posgres files Ramon Orticio
04:18 Unable to vacuum database Pradeepkumar, Pyatalo (IE10)
06:33 Returning an array as a field in a larger query? Alan T. Miller
14:27 Unable to Delete a Row Kevin Crenshaw
14:35 Re: Unable to Delete a Row paul@entropia.co.uk
14:41 Migration from MySQL Glauter Moulin Coelho
15:45 Re: Migration from MySQL Sean Davis
16:14 COPY with multiple character delimiter? Celia McInnis
16:16 Re: Unable to Delete a Row Kevin Crenshaw
16:34 Re: Unable to Delete a Row Steve Tucknott
16:43 Re: Unable to Delete a Row Derrick Betts
17:19 Re: Migration from MySQL Van Ingen, Lane
17:21 ERROR: relation "default_cols" does not exist David Sadler
17:24 Re: Migration from MySQL Volkan YAZICI
17:30 Re: Migration from MySQL Glauter Moulin Coelho
21:25 Re: Unable to Delete a Row Tom Lane

26 May 2005

04:19 Re: ERROR: relation "default_cols" does not exist John DeSoi
20:16 Carriage Returns Disappearing
21:18 Escaped Characters (Quotes, etc...)
21:52 Explain Sugrue, Sean
21:52 Re: Escaped Characters (Quotes, etc...) Tom Lane

27 May 2005

18:14 Re: ERROR: relation "default_cols" does not exist David Sadler

28 May 2005

05:11 Re: ERROR: relation "default_cols" does not exist John DeSoi
07:45 Re: Carriage Returns Disappearing Volkan YAZICI
23:49 Re: ERROR: relation "default_cols" does not exist David Sadler

29 May 2005

12:28 How to Install only DBEngine under Win Info

30 May 2005

09:51 PSQL under Windows XP Danny Gaethofs
13:52 Re: PSQL under Windows XP Kevin Crenshaw
13:53 Re: Unable to Delete a Row Kevin Crenshaw
14:13 Re: PSQL under Windows XP John DeSoi
14:20 Re: PSQL under Windows XP Danny Gaethofs
16:10 Re: PSQL under Windows XP John DeSoi
16:27 Re: PSQL under Windows XP Danny Gaethofs
16:41 Re: PSQL under Windows XP John DeSoi

31 May 2005

09:16 another question concerning TOAST Jessica Ditt
10:42 trigger with arguments Vincent CARON
11:04 Re: trigger with arguments Keith Worthington
13:01 Re: UPDATE with JOIN Keith Worthington
13:56 Re: another question concerning TOAST Tom Lane
17:24 Logical problem with transactions and GUI-clients Andreas
17:36 Re: Logical problem with transactions and GUI-clients Terry Lee Tucker
18:02 THEY FOUND NEW ANTIDOTE Mya Johnson
18:03 Major flood of mail to lists ... Marc G. Fournier
18:07 Little Stox Sizzle Sometimes Abraham
18:07 Re: Carriage Returns Disappearing
18:07 Cancer viruses. This may help. Check it out Melody
18:07 Don't miss this company, it's on the move venus Vogt
18:08 akgwwnj kgwwnjyrtvngitqy@aol.com
18:08 Congratulations! *SKL WINNER* Contact Your Claims Agent. klassenlotterie01
18:09 Industry News Sadie D. Adams, V
18:09 Important News Mohammad
18:09 How to Install only DBEngine under Win Francesco
18:09 ARQUIVOS JURIDICOS CD DO DIREITO
18:09 Functions Nick Jones
18:09 大人の情報メールマガジン局　Vo.0015 Yamamoto makoto
18:09 Re: Library Framework stefan@asemota.ch
18:09 INVESTMENT peter nkosi
19:25 Re: Carriage Returns Disappearing
19:39 Re: Functions John DeSoi
19:41 Re: Functions Tom Lane
19:46 Re: Functions Nick Jones
23:15 Re: Functions John DeSoi