Re: pg_get_serial_sequence is inconsistent
| От | Christopher Kings-Lynne |
|---|---|
| Тема | Re: pg_get_serial_sequence is inconsistent |
| Дата | |
| Msg-id | 4180873B.9070904@familyhealth.com.au обсуждение исходный текст |
| Ответ на | pg_get_serial_sequence is inconsistent (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: pg_get_serial_sequence is inconsistent
|
| Список | pgsql-hackers |
> pg_get_serial_sequence() does dequoting/downcasing on its relation-name
> argument, but not on its column-name argument.
>
> regression=# create table "FOO" ("Ff1" serial);
> NOTICE: CREATE TABLE will create implicit sequence "FOO_Ff1_seq" for serial column "FOO.Ff1"
> CREATE TABLE
> regression=# select pg_get_serial_sequence('FOO','Ff1');
> ERROR: column "Ff1" of relation "foo" does not exist
> regression=# select pg_get_serial_sequence('"FOO"','Ff1');
> pg_get_serial_sequence
> ------------------------
> public."FOO_Ff1_seq"
> (1 row)
I presume the reason for that is that the first paramater can be qualified:
select pg_get_serial_sequence('"public"."FOO"', 'Ff1');
Chris
В списке pgsql-hackers по дате отправления: