comp.databases.postgresql.sql

Re: Copy command freezes but INSERT works fine with trigger oninsert.

Started on 27 August 2004 22:29
Last reply by gsw on 27 August 2004 22:29
[ Posts: 0 ] [ Views: 727 ]

Re: help with trigger

Started on 27 August 2004 21:35
Last reply by dino_vliet on 27 August 2004 21:35
[ Posts: 0 ] [ Views: 824 ]

Re: GRANT ON all tables

Started on 27 August 2004 21:20
Last reply by Bruno on 27 August 2004 21:20
[ Posts: 0 ] [ Views: 863 ]

Pb with insert statement

Started on 26 August 2004 23:12
Last reply by oliverp21 on 26 August 2004 23:12
[ Posts: 0 ] [ Views: 656 ]

Problem with stored procedure

Started on 26 August 2004 15:07
Last reply by a.antoniou on 26 August 2004 16:59
[ Posts: 2 ] [ Views: 675 ]

ERROR: Invalid regular expression: parentheses ( ) not balanced

Started on 22 August 2004 21:51
Last reply by tgl on 26 August 2004 04:54
[ Posts: 3 ] [ Views: 725 ]

Re: CREATE TYPE VARCHAR2

Started on 26 August 2004 04:07
Last reply by tgl on 26 August 2004 04:07
[ Posts: 0 ] [ Views: 694 ]

PQexec and SPI_exec

Started on 25 August 2004 16:21
Last reply by JanWieck on 25 August 2004 16:53
[ Posts: 1 ] [ Views: 693 ]

Optimizer Selecting Incorrect Index

Started on 25 August 2004 16:49
Last reply by dprice on 25 August 2004 16:49
[ Posts: 0 ] [ Views: 675 ]

Re: Possible rounding error of large float values?

Started on 24 August 2004 22:21
Last reply by Iain on 25 August 2004 04:48
[ Posts: 4 ] [ Views: 827 ]

Re: Possible rounding error of large float values?

Started on 24 August 2004 21:52
Last reply by Josh on 24 August 2004 21:52
[ Posts: 0 ] [ Views: 580 ]

refer to computed columns

Started on 24 August 2004 17:10
Last reply by Bruno Mueller on 24 August 2004 17:10
[ Posts: 0 ] [ Views: 671 ]

Disable trigger with Postgresql 7.4.x?

Started on 24 August 2004 09:41
Last reply by pgman on 24 August 2004 13:20
[ Posts: 1 ] [ Views: 2869 ]

stored procedures and type of returned result.

Started on 24 August 2004 10:39
Last reply by dev on 24 August 2004 12:41
[ Posts: 3 ] [ Views: 1251 ]

surrogate key or not?

Started on 20 Juli 2004 14:16
Last reply by Sad on 24 August 2004 06:31
[ Posts: 43 ] [ Views: 907 ]

reply to setting

Started on 07 August 2004 06:03
Last reply by mail on 23 August 2004 23:06
[ Posts: 7 ] [ Views: 682 ]

array_in: '{}}'::text[]

Started on 23 August 2004 13:45
Last reply by mail on 23 August 2004 20:32
[ Posts: 2 ] [ Views: 561 ]

TSearch2 other languages

Started on 23 August 2004 17:12
Last reply by cavit on 23 August 2004 17:12
[ Posts: 0 ] [ Views: 812 ]

disable constrained (contd.)

Started on 22 August 2004 02:41
Last reply by twanger on 23 August 2004 13:51
[ Posts: 1 ] [ Views: 628 ]

pg_dump/pg_restore question

Started on 23 August 2004 04:59
Last reply by dev on 23 August 2004 09:56
[ Posts: 2 ] [ Views: 4602 ]

only last records in subgroups

Started on 17 August 2004 12:44
Last reply by gsstark on 23 August 2004 06:09
[ Posts: 2 ] [ Views: 742 ]

problem with RULE

Started on 20 August 2004 23:17
Last reply by Sreten Milosavljevic on 20 August 2004 23:17
[ Posts: 0 ] [ Views: 650 ]

olympics ranking query

Started on 20 August 2004 18:40
Last reply by Mischa Sandberg on 20 August 2004 20:29
[ Posts: 6 ] [ Views: 673 ]

Problems importing data

Started on 20 August 2004 17:17
Last reply by Devin on 20 August 2004 17:17
[ Posts: 0 ] [ Views: 842 ]

SQL Challenge: Arbitrary Cross-tab

Started on 18 August 2004 04:55
Last reply by tgl on 20 August 2004 05:25
[ Posts: 15 ] [ Views: 762 ]

Function Issue!

Started on 19 August 2004 03:10
Last reply by tgl on 19 August 2004 03:36
[ Posts: 1 ] [ Views: 615 ]

Re: Problem in Stored Procedures

Started on 11 Juli 2004 08:35
Last reply by Theo.Galanakis on 19 August 2004 00:29
[ Posts: 1 ] [ Views: 823 ]

/contrib and win32

Started on 18 August 2004 17:30
Last reply by pgman on 18 August 2004 17:30
[ Posts: 0 ] [ Views: 816 ]

SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo

Started on 17 August 2004 13:07
Last reply by Bruno on 17 August 2004 19:31
[ Posts: 7 ] [ Views: 856 ]

Verifying data type

Started on 16 August 2004 23:16
Last reply by elieser on 17 August 2004 15:48
[ Posts: 2 ] [ Views: 700 ]

Inheriting text[] field

Started on 16 August 2004 09:06
Last reply by news1 on 17 August 2004 15:16
[ Posts: 2 ] [ Views: 586 ]

CROSS-TAB query help? I have read it cant be done in one SQL, pro

Started on 16 August 2004 01:46
Last reply by dev on 17 August 2004 11:48
[ Posts: 3 ] [ Views: 692 ]

any chance SQL ASSERTIONS will be implemented?

Started on 16 August 2004 22:15
Last reply by peter_e on 16 August 2004 22:41
[ Posts: 1 ] [ Views: 564 ]

SQL_ASCII and UNICODE server_encoding

Started on 16 August 2004 15:56
Last reply by tgl on 16 August 2004 17:04
[ Posts: 2 ] [ Views: 2281 ]

Re: Returning A Varchar From A Function

Started on 16 August 2004 14:40
Last reply by gweaver on 16 August 2004 14:40
[ Posts: 0 ] [ Views: 585 ]

SQL newbie

Started on 16 August 2004 11:10
Last reply by David McCallum on 16 August 2004 11:10
[ Posts: 0 ] [ Views: 663 ]

duplicate table in two databases

Started on 12 August 2004 15:42
Last reply by dev on 16 August 2004 10:01
[ Posts: 1 ] [ Views: 962 ]

Re: UNIQUE constraint

Started on 09 August 2004 01:55
Last reply by seltenreich on 16 August 2004 03:03
[ Posts: 1 ] [ Views: 599 ]

Getting points from polygon

Started on 12 August 2004 18:59
Last reply by tgl on 15 August 2004 21:43
[ Posts: 1 ] [ Views: 600 ]

Re: LIKE '%%' does not return NULL

Started on 15 August 2004 20:56
Last reply by sszabo on 15 August 2004 20:56
[ Posts: 0 ] [ Views: 507 ]