Re: [HACKERS] [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-22 Thread Adriaan van Os
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: I presume the reason for that is that the first paramater can be qualified: select pg_get_serial_sequence('"public"."FOO"', 'Ff1'); Would someone explain why qualification makes us lowercase the first parameter by default? I don't und

Re: [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-22 Thread Adriaan van Os
Bruce Momjian wrote: Strangely, this was reported before, but not until November of 2006: http://archives.postgresql.org/pgsql-general/2006-11/msg0.php That was a follow up on this thread . Regards, Adriaan van

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] 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

[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