pgsql-sql since 2001-07-06 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 6, 2001

Thread Author Time
Re: Text manipulation in SQL 📎 Josh Berkus 04:23
Re: ConnecDB() -- couldn't send SSL negotiation packet: Bhuvan A 04:42
While Using COPY COMMAND ... Bhuvan A 06:35
Re: ConnecDB() -- couldn't send SSL negotiation packet: Richard Huxton 07:07
Re: While Using COPY COMMAND ... Bhuvan A 08:38
Re: While Using COPY COMMAND ... Richard Huxton 08:41
Re: ConnecDB() -- couldn't send SSL negotiation packet: Bhuvan A 08:48
Re: ConnecDB() -- couldn't send SSL negotiation packet: Richard Huxton 10:10
"Display of specified number of records." rajesh 10:47
Transactions within a function Daniel Åkerud 12:40
Re: Transactions within a function Jan Wieck 13:23
Cross database foreign keys Morgan Curley 13:30
Re: Transactions within a function Doug McNaught 13:32
RE: While Using COPY COMMAND ... Jeff Eckermann 13:39
finding current oid postgresql 13:46
Re: Transactions within a function Alex Pilosov 13:47
Re: While Using COPY COMMAND ... Peter Eisentraut 14:18
Re: Transactions within a function Peter Eisentraut 14:22
Re: [SQL] Cross database foreign keys Peter Eisentraut 14:32
Re: Cross database foreign keys 📎 Josh Berkus 14:36
Re: Cross database foreign keys Jan Wieck 15:00
Re: finding current oid Peter Eisentraut 15:10
PL/TclU Roberto Mello 15:38
create type of table Jeff Barrett 15:41
Re: Is function atomic? Peter Eisentraut 16:13
Re: PL/TclU Peter Eisentraut 16:14
Is function atomic? Wei Weng 16:41
Re: Is function atomic? Richard Huxton 16:44
Re: Is function atomic? Peter Eisentraut 16:49
Re: Is function atomic? Peter Eisentraut 17:25
Re: Is function atomic? Wei Weng 17:35
Re: Is function atomic? John Hasler 17:40
SQL question Deepali Agarwal 17:52
Re: Is function atomic? Wei Weng 18:17
view and performance Wei Weng 18:38
Re: creating variable views Dado Feigenblatt 22:24
Re: creating variable views Josh Berkus 22:51
indexing of hierarchical data 📎 Dado Feigenblatt 23:15
Re: indexing of hierarchical data Josh Berkus 23:59

July 7, 2001

Thread Author Time
Re: indexing of hierarchical data 📎 Dado Feigenblatt 00:20
Problem with function & trigger Carlo Vitolo 11:05
Re: Is function atomic? Richard Huxton 11:21
Re: view and performance Richard Huxton 11:25
Re: Is function atomic? John Hasler 12:27
Re: Is function atomic? Peter Eisentraut 13:35
Re: creating variable views Tom Lane 19:03
Re: creating variable views Tom Lane 19:11
Re: Problem with function & trigger Tom Lane 19:28
Re: creating variable views Josh Berkus 23:12

July 8, 2001

Thread Author Time
Re: creating variable views Tom Lane 03:49
distributed database Sharmad Naik 04:25
TOTALLY OFFTOPIC !! J.Fernando Moyano 16:47

July 9, 2001

Thread Author Time
how can we change definition of a table once created? Bhuvan A 06:03
Re: how can we change definition of a table once created? Stephan Szabo 06:46
Returning multiple Rows from PL/pgSQL-Function Alvar Freude 09:53
Re: Returning multiple Rows from PL/pgSQL-Function Richard Huxton 11:12
Re: Returning multiple Rows from PL/pgSQL-Function Alex Pilosov 12:54
Re: Returning multiple Rows from PL/pgSQL-Function Alvar Freude 12:56
Re: Returning multiple Rows from PL/pgSQL-Function Richard Huxton 14:03
Re: Returning multiple Rows from PL/pgSQL-Function Alvar Freude 15:45
SQL - histogram Txugo 17:19
Re: PGAccess/pgplsql Blues Bruce Momjian 19:09
Re: PGAccess/pgplsql Blues Josh Berkus 20:07
SQL Project Dave Goldstein 20:19
Re: Problem with function & trigger Carlo Vitolo 21:05

July 10, 2001

Thread Author Time
Help! Failure of pgdump -a Josh Berkus 04:19
Performance tuning in PostgreSQL? 📎 Raymond Chui 12:17
select only the first record juerg.rietmann 13:09
Re: select only the first record Jan Wieck 13:31
Re: select only the first record Christof Glaser 13:38
Problems with PG_DUMP and restore 📎 Josh Berkus 14:50
CREATE TYPE function examples Roberto Mello 15:44
Re: CREATE TYPE function examples Peter Eisentraut 16:43
Re: Problems with PG_DUMP and restore Richard Huxton 16:47
Re: CREATE TYPE function examples Roberto Mello 17:07
Re: "Display of specified number of records." Gene the Dancing Machine 17:13
Re: CREATE TYPE function examples Tom Lane 17:30
duplicated OIDs ? Dado Feigenblatt 17:55
Re: Problems with PG_DUMP and restore Josh Berkus 18:50
Group by date_part Graham Vickrage 19:04
Re: Problems with PG_DUMP and restore 📎 Andre Schnabel 19:35
Re: Group by date_part Roberto Mello 19:36
ERROR: Procedures cannot take more than 16 arguments Kristis Makris 20:34
Re: ERROR: Procedures cannot take more than 16 arguments Peter Eisentraut 20:54
Re: ERROR: Procedures cannot take more than 16 arguments Josh Berkus 21:30
Re: Problem in running the postmaster Tom Lane 23:13
Re: automatic restore of database Grant 23:31
Re: Re: [INTERFACES] distinguishing different database connections Roberto Mello 23:56

July 11, 2001

Thread Author Time
Re: ERROR: Procedures cannot take more than 16 arguments Tom Lane 00:15
Re: SQL question Josh Berkus 00:26
ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found pgsql-bugs 00:34
RE: SQL question Robby Slaughter 02:51
RE: "Display of specified number of records." Robby Slaughter 02:51
Re: SQL - histogram Mathew White 04:39
cumulative sum in aggregate query. David Stanaway 05:30
Select distinct and order by. Carlos 08:41
Re: Problems with PG_DUMP and restore Richard Huxton 08:47
Re: Group by date_part Richard Huxton 08:57
Re: SQL - histogram Richard Huxton 09:06
Re: "Display of specified number of records." Richard Huxton 09:10
File system level backup rocael 09:39
Why lost all foreign key constraits after cluster? 📎 Raymond Chui 12:04
Re: can we write to a flat file from Postgresql procedure Jan Wieck 12:36
Re: cumulative sum in aggregate query. Tom Lane 13:51
Re: can we write to a flat file from Postgresql procedure Peter Eisentraut 14:47
Re: can we write to a flat file from Postgresql procedure Alex Pilosov 15:03
RE: can we write to a flat file from Postgresql procedure Jeff Eckermann 15:15
RE: can we write to a flat file from Postgresql procedure Jeff Eckermann 15:19
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found Tom Lane 15:21
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris 16:04
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found Tom Lane 16:07
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris 16:17
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found Tom Lane 16:40
RE: can we write to a flat file from Postgresql procedure Alex Pilosov 17:51
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris 17:51
Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris 17:51
Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris 17:51
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found Tom Lane 17:56
Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris 18:13
trigger on DELETE Phuong Ma 22:56
Re: trigger on DELETE Stephan Szabo 23:20
Re: trigger on DELETE Kristis Makris 23:23

July 12, 2001

Thread Author Time
epoch to show millseconds Mars G Miro 00:39
C Functions 📎 Fernando Eduardo B. L. e Carvalho 11:33
How Postgresql Compares For Some Query Types Mark kirkwood 11:50
Turn off flushing after each write Wei Weng 14:14
shared memory size Wei Weng 14:30
Functions performed on intervals Jimmie Fulton 14:59
Re: C Functions Patrik Kudo 15:16
Re: trigger on DELETE Thalis A. Kalfigopoulos 16:03
Re: Functions performed on intervals Josh Berkus 16:57
RE: Functions performed on intervals Jimmie Fulton 18:33
Re: Functions performed on intervals Josh Berkus 19:10
Referencing a view? James Orr 20:25
Re: Referencing a view? Stephan Szabo 22:41

July 13, 2001

Thread Author Time
How can we match a condition among 2 diff. tables? bhuvansql 06:11
Re: Referencing a view? Grigoriy G. Vovk 07:33
Executing RECORD's inside a FUNCTION Luis Sousa 09:20
No subselects in constraint (bug?) Alexey V. Neyman 10:16
Re: Referencing a view? James Orr 13:41
Re: Referencing a view? Grigoriy G. Vovk 15:12
Re: Referencing a view? 📎 Josh Berkus 15:14
Date Validation? 📎 Josh Berkus 15:24
Re: How can we match a condition among 2 diff. tables? Stephan Szabo 15:43
Re: How can we match a condition among 2 diff. tables? Peter Eisentraut 16:18
using custom column names in a group by clause Matt Rinkenberger 16:33
Re: Date Validation? Stephan Szabo 16:39
Re: How can we match a condition among 2 diff. tables? Andre Schnabel 16:41
Re: Date Validation? Richard Huxton 17:04
You have an error in your SQL syntax near '' at line 1 Ari Nepon 17:38
Re: Date Validation? Josh Berkus 17:44
Re: No subselects in constraint (bug?) Stephan Szabo 18:25
Re: How can we match a condition among 2 diff. tables? Joe Conway 18:57
Re: No subselects in constraint (bug?) Tom Lane 19:00
Re: You have an error in your SQL syntax near '' at line 1 Josh Berkus 19:01

July 14, 2001

Thread Author Time
Re: Date Validation? dev 15:29
Re: Date Validation? 📎 Josh Berkus 18:40
Help with SQL statement - Thanks Henry 19:16
Re: Help with SQL statement - Thanks Tom Moreau 22:26

July 15, 2001

Thread Author Time
Re: Date Validation? 📎 Christopher Sawtell 03:43
Hey! ORDER BY in VIEWS? 📎 Josh Berkus 17:21
RE: Hey! ORDER BY in VIEWS? Robby Slaughter 18:32
Re: Hey! ORDER BY in VIEWS? Bruce Momjian 18:45
Re: Hey! ORDER BY in VIEWS? Peter Eisentraut 19:30
Re: Hey! ORDER BY in VIEWS? Josh Berkus 19:41
RE: Hey! ORDER BY in VIEWS? Robby Slaughter 20:02
ANNOUNCE: Updated PostgreSQL Notes Richard Huxton 20:58
Re: Hey! ORDER BY in VIEWS? Tom Lane 21:14
Re: Hey! ORDER BY in VIEWS? Josh Berkus 21:40
Re: Hey! ORDER BY in VIEWS? Tom Lane 21:50

July 16, 2001

Thread Author Time
Unknown values in int8 fields? Chris Ruprecht 02:05
RE: Unknown values in int8 fields? Robby Slaughter 02:24
Re: Unknown values in int8 fields? Stephan Szabo 03:48
Re: Hey! ORDER BY in VIEWS? Richard Huxton 06:38
SELECT * from select - HOW? Bhuvan A 08:57
SELECT * FROM select -- got it! Bhuvan A 09:13
is it possible to comment each column of a table? Bhuvan A 10:19
interpreting attributes in pg_class Markus Wagner 10:57
Re: Hey! ORDER BY in VIEWS? Bruce Momjian 14:40
Re: Help with SQL statement - Thanks James Orr 18:31
Re: interpreting attributes in pg_class Peter Eisentraut 20:52

July 17, 2001

Thread Author Time
ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found Dado Feigenblatt 02:46
Re: ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found Richard Huxton 08:37
RE: Re: drop table if exists Maxim Maletsky 10:16
Re: Performance tuning in PostgreSQL? Edipo Elder Fernandes de Melo 11:56
Re: Select distinct and order by. Tod McQuillin 13:25
First steps in plpgsql - language not recognized? Chris Ruprecht 13:48
CAST(ipaddress as text) -- HOW? Bhuvan A 14:05
RE: First steps in plpgsql - language not recognized? Robby Slaughter 15:02
Re: How Postgresql Compares For Some Query Types 📎 Josh Berkus 15:18
Re: First steps in plpgsql - language not recognized? Peter Eisentraut 15:25
Re: Select distinct and order by. Tom Lane 16:00
Re: [SQL] epoch to show millseconds Tom Lane 16:04
Fw: Query Optimisation required Kapil Tilwani 16:14
Building RPMS with plperl (solution) Zot O'Connor 18:25
Re: using custom column names in a group by clause Josh Berkus 18:37
PL/PGSQL and external (flat ASCII) files - Urgent ... :) Chris Ruprecht 20:28
RE: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Robby Slaughter 20:38
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Tom Lane 21:06
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Peter Eisentraut 21:08

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31