On Mon, Oct 11, 2004 at 10:28:22AM +0100, Richard Huxton wrote:
> One thing you might want to test is what happens when you manually
> create a sequence separate from a table, i.e. no such table-name exists.
Instead of querying pg_statio_user_sequences, you could get the
sequences from pg_attrde
Terry Lee Tucker wrote:
> When one moves from version 7.x to 8.x, will my old pgplsql functions
> continue to work with the single quotes
Of course.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you
Question:
When one moves from version 7.x to 8.x, will my old pgplsql functions continue
to work with the single quotes or will everything have to be changed to the
"dollar quoting" functionality?
Thanks...
On Monday 11 October 2004 05:28 am, Richard Huxton saith:
>
> For those that are puzzle
Sim Zacks wrote:
I am in the process of converting an existing database to PostGreSQL
and wrote a generic script to update all of the sequences as they default at 1.
I thought it would be useful to other people who are converting their
databases.
Very nice.
create or replace function UpdateSequence
I am in the process of converting an existing database to PostGreSQL
and wrote a generic script to update all of the sequences as they default at 1.
I thought it would be useful to other people who are converting their
databases.
If anyone can write this script in using plpythonu, I would love to
