pgsql-sql - July 2001

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 1, 2001

Thread Author Time
Re: creating variable views Dado Feigenblatt 00:04
RE:creating variable views Josh Berkus 05:09
My First Function Gary Stainburn 15:30
Re: My First Function omid omoomi 16:39
WAL_FILES? Josh Berkus 19:21
Re: WAL_FILES? Peter Eisentraut 19:44
Re: WAL_FILES? Josh Berkus 21:03

July 2, 2001

Thread Author Time
Multiple Indexes Dennis 15:36
Re: need oracle ROWNUM equivalent --CELKO-- 20:56
Null set Wei Weng 21:57
A free ODBC client to use with any database. Petarian 22:54
How do I print a message in a function? Wei Weng 23:46

July 3, 2001

Thread Author Time
Re: How do I print a message in a function? Jie Liang 00:59
traversing foreign key relationships between tables Markus Wagner 06:46
indexing arrays in pgaccess's query interface is failing David Stanaway 09:05
problem with date/time constants datactrl 12:44
Re: problem with date/time constants David Stanaway 13:03
Re: problem with date/time constants Alex Pilosov 13:08
Re: problem with date/time constants Jan Wieck 13:31
RE: How do I print a message in a function? Jeff Eckermann 14:08
Re: [SQL] indexing arrays in pgaccess's query interface is failing Tom Lane 14:41
Re: pls Help us... (sql question) Ross J. Reedstrom 14:47
count(*) Martín Marqués 14:54
Re: distinguishing different database connections Manika Dey 16:07
Re: My First Function Gary Stainburn 16:08
Re: count(*) Martín Marqués 16:17
Re: Re: pls Help us... (sql question) Richard Huxton 16:19
Re: count(*) Martín Marqués 16:27
drop table if exists Jason Watkins 21:24
Re: count(*) Alex Pilosov 22:18
Re: count(*) Alex Pilosov 22:31
Re: drop table if exists Philip Hallstrom 22:38
Re: simple function crashes my postmaster Tom Lane 22:52
Re: drop table if exists Jason Watkins 23:05
Re: count(*) Tom Lane 23:41

July 4, 2001

Thread Author Time
Re: problem with date/time constants Bhuvan A 04:45
Re: My First Function omid omoomi 12:40
Re: My First Function Gary Stainburn 12:41
Re: count(*) Martín Marqués 12:44
Re: Re: [SQL] indexing arrays in pgaccess's query interface is failing Constantin Teodorescu 13:02
Problem in running the postmaster Raghavendra 13:18
Updated rowcount Jason Alexander 16:42
sql startment problem PLEASE HELP ..... penny 17:49
Re: sql startment problem PLEASE HELP ..... Stephen Bell 17:57
Kind of error-handler in a pgsql function DI Hasenöhrl 19:37

July 5, 2001

Thread Author Time
Re: Kind of error-handler in a pgsql function Tom Lane 00:38
Re: Kind of error-handler in a pgsql function Alex Pilosov 03:12
Re: Re: Help!!! Trying to "SELECT" and get a tree structure back. Markus Wagner 06:27
Re: Kind of error-handler in a pgsql function DI Hasenöhrl 08:02
Re: My First Function omid omoomi 08:26
automatic restore of database Jacky Cheang 09:40
Re: sql startment problem PLEASE HELP ..... Mark D Powell 13:42
Re: ConnecDB() -- couldn't send SSL negotiation packet: Richard Huxton 13:47
Re: Kind of error-handler in a pgsql function Alex Pilosov 14:29
can we write to a flat file from Postgresql procedure R Vijayanath 15:34
Re: Re: Using Random Sequence as Key Ken Corey 15:44
Re: automatic restore of database Dennis 21:57
Re: Re: automatic restore of database clayton cottingham 22:23

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

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