In another thread (Re: [GENERAL] Return value of 'serial' column on insert)
Bruno Wolff wrote
...
> You can use the currval function to get the id. Normally the sequence
> will have a name like table_column_seq. In 8.0, there is a function
> you can use to get the sequence name, which is a bit mor
I have a function to convert a single dimension array to a row set
CREATE OR REPLACE FUNCTION arraytotable(anyarray)
RETURNS SETOF anyelement AS
'
DECLARE
theData ALIAS FOR $1;
count integer;
start integer;
BEGIN
start :=array_lower(theData,1);
count :=array_upper(theData,1);
Magnus wrote:
> You should run the Cygwin tools from Cygwin. They work fine against a
> native backend.
Thanks, I'll have to wait for the port of P8.0.0 rc4 to cygwin as the
current cygwin port of pg_dump is 8.0.0 B2 and does not work correctly for
reason of the error 'column "nsptablespace" does
I have many database build scripts written for cygwin bash. These scripts
use the cygwin port of postgres 7.4 and its client tools like psql, pg_dump
etc.
I have modified my bash scripts to use the Postgres 8 native windows tools.
Unfortunately these bash scripts don't seem to work.
Some example r
