pgsql-sql since 2006-10-11 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Oct. 11, 2006

Thread Author Time
Re: Temp tables and functions Jim C. Nasby 02:11
Re: Temp tables and functions Mark R. Dingee 11:02
Re: optimal insert Markus Schaber 12:31
Re: deleting rows in specific order Markus Schaber 12:48
Re: deleting rows in specific order Daniel Drotos 19:31

Oct. 12, 2006

Thread Author Time
slow view Stuart 01:18
Re: slow view Stuart McGraw 04:15
Is this a bug? Deleting a column deletes the constraint. Bryce Nesbitt 05:11
Re: Is this a bug? Deleting a column deletes the constraint. Tom Lane 05:25
Re: Is this a bug? Deleting a column deletes the constraint. Joe 09:39
Re: Is this a bug? Deleting a column deletes the constraint. Tom Lane 14:39
Re: Is this a bug? Deleting a column deletes the constraint. Chris Browne 14:56
Re: Is this a bug? Deleting a column deletes the constraint. Florian Weimer 16:19
spliting a row to make several rows Gerardo Herzig 22:18
Re: spliting a row to make several rows Bricklen Anderson 22:42
Re: spliting a row to make several rows Gerardo Herzig 23:00

Oct. 13, 2006

Thread Author Time
could not connect to server ivan marchesini 06:52
Re: could not connect to server A. Kretschmer 07:27
Re: could not connect to server ivan marchesini 09:01
Re: could not connect to server A. Kretschmer 09:18
Re: deleting rows in specific order Markus Schaber 11:48
Re: could not connect to server Tom Lane 14:07
Re: storing access rights in a postgres database Aaron Bono 21:16

Oct. 14, 2006

Thread Author Time
Foreign key reference counting strategy? Joost Kraaijeveld 12:25
Re: Foreign key reference counting strategy? Markus Schaber 13:52
Re: Assigning a timestamp without timezone to a timestamp chrisj 21:42
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 23:26
Re: Foreign key reference counting strategy? Michael Fuhr 23:48
Re: Foreign key reference counting strategy? Tom Lane 23:58

Oct. 15, 2006

Thread Author Time
Re: Foreign key reference counting strategy? Michael Fuhr 00:11
Re: Foreign key reference counting strategy? Tom Lane 00:20
Re: Foreign key reference counting strategy? Michael Fuhr 01:07
Re: Foreign key reference counting strategy? Tom Lane 02:10
conversion of numeric field from MSSQL to postgres Kenneth Gonsalves 12:31
migrating numeric to serial from MSSQL to postgres Kenneth Gonsalves 13:05
Re: migrating numeric to serial from MSSQL to postgres Daniel CAUNE 13:49
Re: migrating numeric to serial from MSSQL to postgres Terry Fielder 13:54
Re: migrating numeric to serial from MSSQL to postgres Daniel CAUNE 15:23
Temp tables, reports in Postgresql (and other RDBMS) ow 16:08
Re: Temp tables, reports in Postgresql (and other RDBMS) Tom Lane 16:54
Re: Temp tables, reports in Postgresql (and other RDBMS) ow 18:10

Oct. 16, 2006

Thread Author Time
Re: Assigning a timestamp without timezone to a timestamp chrisj 02:32
Recursive pl/pgsql function ... Marc G. Fournier 02:39
Re: Recursive pl/pgsql function ... Tom Lane 03:27
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 03:31
Re: Recursive pl/pgsql function ... Marc G. Fournier 06:16
Re: Recursive pl/pgsql function ... Markus Schaber 09:20
hi i want help on levels Penchalaiah P. 14:47
Re: get_next_billing_date() ... Marc G. Fournier 17:25
Re: deleting rows in specific order Bruno Wolff III 17:51

Oct. 17, 2006

Thread Author Time
Re: Assigning a timestamp without timezone to a timestamp chrisj 03:27
How to split a table? Felix Zhang 07:39
Any documatation about porting from Oracle to PostgreSQL Felix Zhang 07:50
Re: How to split a table? Andreas Kretschmer 08:34
Re: Any documatation about porting from Oracle to PostgreSQL Andreas Kretschmer 08:36
Re: Any documatation about porting from Oracle to PostgreSQL Thomas Kellerer 08:44
Can we convert from Postgres to Oracle !!??? Sandeep Kumar Jakkaraju 08:51
Re: [SQL] How to split a table? Gregory S. Williamson 08:53
Re: [NOVICE] How to split a table? Felix Zhang 09:07
Re: [GENERAL] How to split a table? Achilleas Mantzios 09:09
Re: [SQL] [GENERAL] How to split a table? A. Kretschmer 09:12
Re: [SQL] [GENERAL] How to split a table? Gregory S. Williamson 09:19
Re: [NOVICE] How to split a table? Christoph Frick 09:26
Re: Any documatation about porting from Oracle to PostgreSQL A. Kretschmer 09:36
Re: Any documatation about porting from Oracle to PostgreSQL Shane Ambler 10:25
Re: [SQL] [GENERAL] How to split a table? Jorge Godoy 10:51
Re: [NOVICE] How to split a table? Obe, Regina 10:54
Fwd: Re: [GENERAL] How to split a table? Achilleas Mantzios 11:08
Re: Can we convert from Postgres to Oracle !!??? Berend Tober 12:38
Re: [SQL]Any documatation about porting from Oracle to PostgreSQL Lewis Cunningham 13:20
Re: Can we convert from Postgres to Oracle !!??? Ron Johnson 13:22
Re: Can we convert from Postgres to Oracle !!??? Harald Armin Massa 13:22
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 13:34
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:42

Oct. 18, 2006

Thread Author Time
Bug? Indira Muthuswamy 13:23
Re: Bug? Andrew Dunstan 13:31
plpgsql record as parameter ??? Andy 13:49
Re: [HACKERS] Bug? Jim C. Nasby 18:43
Re: hi i want help on levels Jim C. Nasby 23:18

Oct. 19, 2006

Thread Author Time
Re: Any documatation about porting from Oracle to PostgreSQL Robert Treat 01:57
Re: [HACKERS] Bug? Indira Muthuswamy 06:58
Grouping by day, limiting amounts 📎 Mezei Zoltán 11:51
Re: Grouping by day, limiting amounts A. Kretschmer 12:30
Re: Grouping by day, limiting amounts A. Kretschmer 14:17
Re: Grouping by day, limiting amounts Woody Woodring 14:45
Re: [HACKERS] Bug? Jim C. Nasby 16:50
Re: Grouping by day, limiting amounts Jim C. Nasby 16:55

Oct. 20, 2006

Thread Author Time
PostgreSQL 8.1.5 Documentation - Chapter 32. Extending SQL Rares Vernica 03:14

Oct. 21, 2006

Thread Author Time
Re: conversion of numeric field from MSSQL to postgres Daniel CAUNE 03:55
Re: conversion of numeric field from MSSQL to postgres Richard Broersma Jr 04:01
Re: PostgreSQL 8.1.5 Documentation - Chapter 32. Extending SQL Michael Fuhr 04:37
Re: conversion of numeric field from MSSQL to postgres Tom Lane 04:42
Re: conversion of numeric field from MSSQL to postgres Richard Broersma Jr 05:10
Re: [HACKERS] Bug? Richard Broersma Jr 15:25
Re: [SQL] Can we convert from Postgres to Oracle !!??? Devrim GUNDUZ 21:03

Oct. 22, 2006

Thread Author Time
Re: [SQL] Can we convert from Postgres to Oracle !!??? Berend Tober 01:48
Re: [SQL] Can we convert from Postgres to Oracle !!??? Joshua D. Drake 02:49
Re: [SQL] Can we convert from Postgres to Oracle !!??? Steve Atkins 03:10
Re: [SQL] Can we convert from Postgres to Oracle !!??? Alvaro Herrera 03:54
Re: [SQL] Can we convert from Postgres to Oracle !!??? Ron Johnson 04:17
DELETE RETURNING Daniel CAUNE 04:21
Crosstab question Leendert Paul Diterwich 11:57
Re: Crosstab question Michael Fuhr 15:45

Oct. 23, 2006

Thread Author Time
delete on cascade Luca Ferrari 08:49
Re: delete on cascade Achilleas Mantzios 09:00
Re: delete on cascade Luca Ferrari 09:50
Re: delete on cascade Achilleas Mantzios 10:28
Re: delete on cascade Richard Broersma Jr 15:41
Re: delete on cascade chester c young 15:41
Re: delete on cascade Stephan Szabo 15:48
Re: conversion of numeric field from MSSQL to postgres Andrew Sullivan 17:16
Re: delete on cascade Richard Broersma Jr 19:04

Oct. 24, 2006

Thread Author Time
Re: [NOVICE] Can we convert from Postgres to Oracle !!??? Chander Ganesan 16:18

Oct. 26, 2006

Thread Author Time
Add calculated fields from one table to other table roopa perumalraja 01:07
Re: Add calculated fields from one table to other table Aaron Bono 01:59
Re: Add calculated fields from one table to other table chester c young 15:29
Re: Add calculated fields from one table to other table Richard Broersma Jr 17:59
Re: plpgsql record as parameter ??? Aaron Bono 22:57

Oct. 27, 2006

Thread Author Time
Re: [SQL] Can we convert from Postgres to Oracle !!??? Jim C. Nasby 03:06
How to query information schema from shell script Jon Horsman 13:31
Re: How to query information schema from shell script A. Kretschmer 13:46
Re: How to query information schema from shell script George Pavlov 13:47
Re: How to query information schema from shell script William Leite Araújo 13:55
Re: How to query information schema from shell script Jon Horsman 13:57
not able to execute query on spatial database. vamsee movva 14:34
Re: How to query information schema from shell script Jon Horsman 15:12
Re: How to query information schema from shell script Jon Horsman 15:22
Re: not able to execute query on spatial database. Aaron Bono 15:25
Re: How to query information schema from shell script George Pavlov 15:43
Function to reset sequence..... Doug Hyde 16:28
Re: [SQL] Can we convert from Postgres to Oracle !!??? Richard Troy 18:00
Re: How to query information schema from shell script Scott Marlowe 19:14
Case Preservation disregarding case sensitivity? beau hargis 23:23

Oct. 28, 2006

Thread Author Time
Re: Case Preservation disregarding case sensitivity? Frank Bax 01:50
Re: Case Preservation disregarding case sensitivity? Joe 02:38
Re: How to query information schema from shell script Richard Broersma Jr 04:09
Re: Case Preservation disregarding case sensitivity? Richard Broersma Jr 14:38
Re: Case Preservation disregarding case sensitivity? Richard Broersma Jr 14:59
Re: How to query information schema from shell script Jon Horsman 15:18

Oct. 29, 2006

Thread Author Time
fetching unique pins in a high-transaction environment... Bobus 16:36
Re: not able to execute query on spatial database. Michael Fuhr 17:10

Oct. 30, 2006

Thread Author Time
Re: Add calculated fields from one table to other table roopa perumalraja 02:50
Re: Add calculated fields from one table to other table Richard Broersma Jr 03:12
Re: Add calculated fields from one table to other table roopa perumalraja 05:34
Re: Add calculated fields from one table to other table Moiz Kothari 05:47
Re: fetching unique pins in a high-transaction environment... Bobus 06:13
Database recovery in postgres 7.2.4. Santosh 10:25
Re: Add calculated fields from one table to other table roopa perumalraja 23:19

Oct. 31, 2006

Thread Author Time
Re: Add calculated fields from one table to other table roopa perumalraja 03:01
Re: Case Preservation disregarding case sensitivity? Tom Lane 03:23
Re: Case Preservation disregarding case sensitivity? beau hargis 03:28
Re: Add calculated fields from one table to other table Richard Broersma Jr 03:32
Re: Add calculated fields from one table to other table Moiz Kothari 06:06
Re: [HACKERS] Case Preservation disregarding case Chuck McDevitt 06:08
Re: [HACKERS] Case Preservation disregarding case sensitivity? Tom Lane 06:34
Re: Add calculated fields from one table to other table roopa perumalraja 06:54
Re: Add calculated fields from one table to other table Richard Broersma Jr 13:27
refining view using temp tables BeemerBiker 17:01
Re: [HACKERS] Case Preservation disregarding case Chuck McDevitt 17:11
Re: [HACKERS] Case Preservation disregarding case Chuck McDevitt 17:13
Table Relationships Curtis Scheer 17:15
Re: [HACKERS] Case Preservation disregarding case Andrew Dunstan 17:55
Re: [HACKERS] Case Preservation disregarding case Martijn van Oosterhout 18:06
Re: [HACKERS] Case Preservation disregarding case Stephan Szabo 18:22
Re: [HACKERS] Case Preservation disregarding case Chuck McDevitt 18:32
Re: Table Relationships A. Kretschmer 18:48
Re: Table Relationships Aaron Bono 19:32
Round Numeric Type Ezequias Rodrigues da Rocha 19:35
Composite Types Jose 19:50
Re: Table Relationships A. Kretschmer 20:08
Re: Table Relationships A. Kretschmer 20:13
record datatype comparisons George Pavlov 20:38
Re: Table Relationships Aaron Bono 20:43
Re: Round Numeric Type Andrew Sullivan 21:18
Re: record datatype comparisons Andrew Sullivan 21:22
Re: record datatype comparisons George Pavlov 21:33
Re: record datatype comparisons Volkan YAZICI 21:45
Re: record datatype comparisons Alvaro Herrera 21:49
Re: record datatype comparisons Volkan YAZICI 21:58
Re: Table Relationships Curtis Scheer 22:04

Nov. 1, 2006

Thread Author Time
Re: Add calculated fields from one table to other table roopa perumalraja 03:54
Re: Add calculated fields from one table to other table Richard Broersma Jr 05:51
Re: [HACKERS] Case Preservation disregarding case Tom Lane 06:38
Re: Add calculated fields from one table to other table roopa perumalraja 06:49
Re: Round Numeric Type Ezequias Rodrigues da Rocha 12:06
Re: record datatype comparisons Andrew Sullivan 14:28
Re: record datatype comparisons Andrew Sullivan 14:32
Distribution of results Raghuraman K 16:17
Re: [HACKERS] Case Preservation disregarding case Chuck McDevitt 16:31
Statement Triggers and access to other rows in the transaction Craig Servin 16:50
Re: record datatype comparisons Volkan YAZICI 21:00
Re: record datatype comparisons Andrew Sullivan 21:07

Nov. 2, 2006

Thread Author Time
Re: [HACKERS] Case Preservation disregarding case Simon Riggs 10:27
hi i am getting error...can u solve this Penchalaiah P. 12:49
Re: hi i am getting error...can u solve this Andrew Sullivan 13:39
Re: [HACKERS] Case Preservation disregarding case Tom Lane 15:51
Postgres-R Anton P. Linevich 17:16
Re: Postgres-R Andrew Sullivan 17:51
Is there anyway to... louis gonzales 18:14
Re: hi i am getting error...can u solve this Hector Villarreal 18:18

Browse Archives

Prev | Next