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
.
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
;. 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
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,
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:/
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
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
>
', '(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
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
,
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
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
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
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);
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
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
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
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
17 matches
Mail list logo