Hi all,
i have a little question on getting the last inserted value from a
table.
Lets say i have a transaction which does the following.
insert into foo values(1);
insert into bar values(2);
insert into foobar values(3);
All three tables use the same sequence to increment their id.
I want to
I've run into what I think is a problem with pg_dump.
I'm running 7.1.2 under RedHat.
I issue a schema-only pg_dump as follows:
pg_dump -c -s -S postgres me|gzip>
/u0/prod/sql/backups/$YEAR.$MONTH.$DAY.schema.gz
Everything seems to run fine. However, upon restore no views were seen.
Investiga
I created a function with iscachable,
' LANGUAGE 'plpgsql' WITH (iscachable);
I then call the function.
Then I decide to change the return type of the function so I first drop
the
function, then change the return type.
The next time I attempt to execute the function I get:
ERROR: plpgsql: cac
On Wed, 27 Mar 2002 [EMAIL PROTECTED] wrote:
> Hello all.
>
> I'v migrated my data to 7.2.
> Now I'm testing aplications, but looks like timestamp function in
> postgres is broken:
> klienti=# select date(now());
> date
>
> 2002-03-27
> (1 row)
>
> klienti=# select timestamp(da
I have an empty database that we recreated from scratch in order to make
some column changes. I would like to restore the data that was in the original
database. Will it work given that their are some new fields that did not exist
before? Am I correct in that I cannot do this from pg_restore
Jodi Kanter wrote:
> We are currently trying to determine if their is a performance
> difference with postgres in using an IN statement in the where clause
> vs. using a join between tables.
>
> Is there any published documentation or someone with personal experience
> that can answer this que
We are currently trying to determine if their is a performance difference
with postgres in using an IN statement in the where clause vs. using a join
between tables.
Is there any published documentation or someone with personal experience
that can answer this question? We are adding sessioni
On Wed, Mar 27, 2002 at 12:55:54PM +0200, [EMAIL PROTECTED] wrote:
> Hello all.
>
> I'v migrated my data to 7.2.
> Now I'm testing aplications, but looks like timestamp function in
> postgres is broken:
> klienti=# select date(now());
> date
>
> 2002-03-27
> (1 row)
>
> klien
Hello all.
I'v migrated my data to 7.2.
Now I'm testing aplications, but looks like timestamp function in
postgres is broken:
klienti=# select date(now());
date
2002-03-27
(1 row)
klienti=# select timestamp(date(now()));
ERROR: parser: parse error at or near "date"
I need t
