Michal Schwarz <[EMAIL PROTECTED]> writes:
> Ie. psql 7.2 obviously EXPECTS quotes, while pg_dump and pg_dumpall DO NOT
> GENERATE them.
This is fixed in 7.2.1 (we reverted psql's behavior).
regards, tom lane
---(end of broadcast)-
Michal Schwarz <[EMAIL PROTECTED]> writes:
> SELECT * FROM returns following error message:
> ERROR: replace_vars_with_subplan_refs: variable not in subplan target list
This is fixed in 7.2.1 (or at least, a related problem was fixed, and
I don't see any failure with your example...)
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Tue, 16 Apr 2002, Rod Taylor wrote:
>> You'll notice there isn't a primary key at all -- which shouldn't be
>> an issue as there is still the unique.
> If you're not specifying the columns in the references constraint, it
> means specifically referen
Sorry to sound like a broken record, but this is also fixed in 7.2.1.
---
Michal Schwarz wrote:
> Problem:
>
> pg_dump does not honour case-sensitivity in user names, which results to
> failures when restoring data
Please upgrade to 7.2.1. It is fixed there.
---
Michal Schwarz wrote:
> Problem:
>
> SELECT * FROM returns following error message:
> ERROR: replace_vars_with_subplan_refs: variable not in subplan target list
>
b=# create table stuff (stuff_id serial unique);
NOTICE: CREATE TABLE will create implicit sequence
'stuff_stuff_id_seq' for SERIAL column 'stuff.stuff_id'
NOTICE: CREATE TABLE / UNIQUE will create implicit index
'stuff_stuff_id_key' for table 'stuff'
CREATE
b=# create table stuff2 (stuff_id int
Problem:
pg_dump does not honour case-sensitivity in user names, which results to
failures when restoring database.
Environment:
Version: PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
System: Linux jtam.brno.czechin.cz 2.2.17-RAID #8 SMP Mon Oct 16 10:48:13
CES
Problem:
SELECT * FROM returns following error message:
ERROR: replace_vars_with_subplan_refs: variable not in subplan target list
Environment:
Version: PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
System: Linux jtam.brno.czechin.cz 2.2.17-RAID #8 SMP Mon Oc
On Tue, 16 Apr 2002, Rod Taylor wrote:
> b=# create table stuff (stuff_id serial unique);
> NOTICE: CREATE TABLE will create implicit sequence
> 'stuff_stuff_id_seq' for SERIAL column 'stuff.stuff_id'
> NOTICE: CREATE TABLE / UNIQUE will create implicit index
> 'stuff_stuff_id_key' for table 's
