Re: [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-19 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Adriaan van Os wrote: >> In order to work with capitals (etc.), the table_name parameter of >> pg_get_serial_sequence needs double quotes inside single quotes, the >> column_name parameter requires a name within single quotes only. > I can confirm this i

Re: [BUGS] PostgreSQL & Slackware

2007-01-19 Thread Tom Lane
Devrim GUNDUZ <[EMAIL PROTECTED]> writes: > On Fri, 2007-01-19 at 04:18 -0800, Milton C=C3=A9sar de Souza Leite wrote: >> configure: error: C preprocessor "/lib/cpp" fails sanity check > AFAIR, you need to install gcc-g++ package for Slackware to get rid of > this error. The failure appears to in

Re: [BUGS] BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

2007-01-19 Thread Bruce Momjian
David Higgs wrote: > On 1/13/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "David" <[EMAIL PROTECTED]> writes: > > > This statement works: > > > => SELECT * FROM sal_emp WHERE 1 = ANY (pay_by_quarter); > > > > > But this does not: > > > => SELECT * FROM sal_emp WHERE ANY (pay_by_quarter) = 1;

Re: [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-19 Thread Bruce Momjian
Adriaan van Os wrote: > > The following bug has been logged online: > > Bug reference: 2907 > Logged by: Adriaan van Os > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: Mac OS X 10.4.6, intel > Description:pg_get_serial_sequence quoti

Re: [BUGS] PostgreSQL & Slackware

2007-01-19 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-19 at 04:18 -0800, Milton César de Souza Leite wrote: > configure: error: C preprocessor "/lib/cpp" fails sanity check AFAIR, you need to install gcc-g++ package for Slackware to get rid of this error. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564

Re: [BUGS] BUG #2912: postgres database connectivity

2007-01-19 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-19 at 11:07 +, Aravind wrote: > PostgreSQL version: 8.0 > Operating system: Suse linux > Description:postgres database connectivity > Details: > > when the postgres database is connected through pgadminIII the > connection > tells Fatal error: Already roo many c

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-19 Thread Adriaan van Os
Bruce Momjian wrote: Adriaan van Os wrote: The following bug has been logged online: Bug reference: 2905 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:min and max return inco

Re: [BUGS] BUG #2906: slow windows network performance

2007-01-19 Thread Adriaan van Os
jose fuenmayor wrote: Use linux mac or any other unix like operating system, it performs better in every aspect. Thank you for your wonderful advice, but this is really a bug report. Adriaan van Os ---(end of broadcast)--- TIP 3: Have you checke

[BUGS] BUG #2913: Subscript on multidimensional array yields no value

2007-01-19 Thread Roman Nowak
The following bug has been logged online: Bug reference: 2913 Logged by: Roman Nowak Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: Windows XP Description:Subscript on multidimensional array yields no value Details: SELECT (ARRAY[[1,2],

[BUGS] PostgreSQL & Slackware

2007-01-19 Thread Milton César de Souza Leite
I am having problems for compiler PostgreSQL 8.2.0 in Slackware 11.0. I used this parameters in configure: % ./configure --with-includes=/usr/src/linux/include showing after the error: ... configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-state

[BUGS] BUG #2910: Setting timestamps to null doesn't work with PDO

2007-01-19 Thread Michael Vogel
The following bug has been logged online: Bug reference: 2910 Logged by: Michael Vogel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: Windows Description:Setting timestamps to null doesn't work with PDO Details: Hi! We are having probl

[BUGS] BUG #2908: ISO8601 Date / Time Format Incompatibility

2007-01-19 Thread David Lloyd
The following bug has been logged online: Bug reference: 2908 Logged by: David Lloyd Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Solaris 10 Description:ISO8601 Date / Time Format Incompatibility Details: According to the ISO standard,

[BUGS] BUG #2912: postgres database connectivity

2007-01-19 Thread Aravind
The following bug has been logged online: Bug reference: 2912 Logged by: Aravind Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Suse linux Description:postgres database connectivity Details: when the postgres database is connected through

[BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-19 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2907 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:pg_get_serial_sequence quoting Details: In order to work with capi

Re: [BUGS] BUG #2848: information_schema.key_column_usage

2007-01-19 Thread Bruce Momjian
This has has been fixed in CVS HEAD and 8.2.X will get the fix if the drop and recreate the view, or initdb. --- Tom Lane wrote: > Laurence Rowe <[EMAIL PROTECTED]> writes: > >> I have the following query: > >> > >> SELECT

Re: [BUGS] BUG #2904: COPY FROM -> permisson denied

2007-01-19 Thread Tom Lane
"Izsak Rudolf" <[EMAIL PROTECTED]> writes: > Operating system: Fedora Core 6 > Description:COPY FROM -> permisson denied > I wanted to COPY the content of the sample data file /home/csakmost.txt to > my data table t_crdc1 using the following command: > exp03038=# COPY t_crdc1 FROM '/home

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-19 Thread Bruce Momjian
Adriaan van Os wrote: > > The following bug has been logged online: > > Bug reference: 2905 > Logged by: Adriaan van Os > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: Mac OS X 10.4.6, intel > Description:min and max return incorrect