[SQL] Re: [GENERAL] Re: Mirroring the database?

There's also PostgreSQL Replicator (which I haven't gotten around to trying) : http://pgreplicator.sourceforge.net :-) Regards and best wishes, Justin Clift Allan Engelhardt wrote: > > Ehhh, use dual-ported RAID disks? (Well, tri-port in your case, but maybe A and B >

Re: [SQL] has anyone tried running in MAC OS X

t. If you need further assistance, feel free to ask. :-) Regards and best wishes, Justin Clift Tom Lane wrote: > > "postgresql" <[EMAIL PROTECTED]> writes: > > I guess the subject line says ithas anyone tried running > > PostgreSQL in MAC OS X. > > S

Re: [SQL] system time

select now(); ??? + Justin Seema Noor wrote: > > is there any function from which i can get system time? > > > Do You Yahoo!? > Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk > or your free @yahoo.ie address at http:/

Re: [SQL] execute client application from PL/pgSql

ding quite nicely. :-) Regards and best wishes, Justin Clift Jeff MacDonald wrote: > > hi, > > phpPGAdmin is a web based php driven postgresql > admin tool. not sure of the exact url, try > google :) > > it has a pg_dump option in it. > > jeff > > On Sat,

Re: [SQL] error message...

;. If it starts it with "postmaster", then use -N directly, without the -o. The man pages for pg_ctl and postmaster should be of some benefit also. Regards and best wishes, Justin Clift "S.E.Franke" wrote: > > Hi I have Postgres 7.0.3/6 on a Suse Professional 7.1 (ke

Re: [SQL] any proper benchmark scripts?

. Out of curiosity do you have access to other databases such as Interbase, Oracle, DB2, Informix, and so forth? The more it can connect to, the better people will be able to understand each one's strengths and weaknesses, in terms of Perl's DB access. Regards and best wishes, Justin Clif

Re: [SQL] Range of Serial values

Hi, I believe you could also create the sequence, then update it with setval('', ); Regards and best wishes, Justin Clift "Poul L. Christiansen" wrote: > > Yes, there is. > > When you create a serial column a sequence is created, which does the > cou

Re: [SQL] Function Vanished

Hi would it work to do a pg_dump -d or a pgdumpall, then look through the dumped sql file? I do that to retrieve PL/pgSQL functions from the database when I've accidentally wiped or modified the source (not often, but it happens). Regards and best wishes, Justin Clift Tom Lane

Re: [SQL] quotes in pl/pgsql

Hi Najm, Is this what you mean? CREATE FUNCTION foobar(int4) returns int4 as 'DECLARE textbuf varchar(120); BEGIN  textbuf := ''Example Text ''; insert into sometable (something) values (textbuf); RETURN 0; END;' LANGUAGE 'plpgsql'; Najm Hashmi wrote: > > Hi all, I

[SQL] Help needed -> ERROR: record arow has no field description

tried several variations, and the mailing lists don't even have a reference for this error message. Regards and best wishes, Justin Clift Database Administrator ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister c

[SQL] Re: Help needed -> ERROR: record arow has no field description

me to add a section on error messages into techdocs.postgresql.org (very messy at the moment, I'll fix it tonight). Regards and best wishes, + Justin Clift Database Administrator Justin Clift wrote: > > Hi all, > > I'm getting this error, which to me makes no sense

[SQL] HELP: Scarey pl/pgsql problem

below : CREATE FUNCTION which_block(time) RETURNS time AS 'DECLARE /* Given a time, this function works out the name of the correct field in the reservations table for it * Written by : Justin Clift * Date : 1st February 2001 * Version: 1.00 */ hours char(3);

[SQL] Re: HELP: Scarey pl/pgsql problem

est box. After installing the Postgres 7.0.3 rpms from the PostgreSQL site, pl/pgsql is working consistently again. It looks like the rpms for PostgreSQL supplied with Mandrake Linux 7.2 are broken, I guess they didn't run the supplied tests before packaging. :-( Regards and best wishes, J

Re: [SQL] Possible bug? WAS :Bad (null) varchar() external representation.

om has also suggested using COALESCE instead, so I'll check this out too. Regards and best wishes, Justin Clift Database Administrator Tom Lane wrote: > > > The reason I'm using constraints in the table is to allow the database > > to recognise when oversize data is bei

Re: [SQL] Possible bug? WAS :Bad (null) varchar() external representation.

, Justin Clift Database Administrator Tom Lane wrote: > > Justin Clift <[EMAIL PROTECTED]> writes: > > I haven't seen a mention of a maximum number of constraints of similar > > applying to a table. If so, then could someone please point me to it... > > Th

[SQL] Possible bug? WAS :Bad (null) varchar() external representation.

1', encrypt('foo'), 'Joshua', 1, '1970-07-01', '(03) 9867 5432', '(041) 309 2819', NULL, '1 Blankety-Blank Way\nBazzville', NULL, NULL); INSERT 27605472 1 Removing EITHER of these constraints doesn't work, and n

[SQL] Bad (null) varchar() external representation

', '(041) 309 2819', NULL, '1 Blankety-Blank Way\nBazzville', NULL, NULL); ERROR: Bad (null) varchar() external representation etc... I've tried everything I can think of, also exported and reloaded the database, etc. This is a new table with nothing in it. This is driving me nuts. :-( + Justin Clift Database Administrator