[SQL] Help with regexp-query

2011-08-02 Thread Johann Spies
ith 'ERROR: invalid regular expression: quantifier operand invalid'. I would apreciate some help with this one please. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnolog

Re: [SQL] pg_dump error - further information

2001-01-16 Thread Johann Spies
On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: > I would guess that this means there is a file named "pgdump_oid" hanging > around in the database directory, no doubt leftover from some previous > pg_dump cycle. Manually removing the file should get you up and running > again. However

Re: [SQL] pg_dump error

2001-01-16 Thread Johann Spies
On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: > Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Can not create pgdump_oid table. Explanation from backend: 'ERROR: > cannot create pgdump_oid > > Is there a way to repair this? > > I would guess that this means there is

[SQL] pg_dump error

2001-01-15 Thread Johann Spies
Version 6.5.3 on Debian Potato My daily cron job reported : Can not create pgdump_oid table. Explanation from backend: 'ERROR: cannot create pgdump_oid Is there a way to repair this? Johann -- J.H. Spies - Tel. 082 782 0336 "For I know that my redeemer liveth, and that he shall

Re: [SQL] how many rows? [was Re: fetching rows]

2000-11-18 Thread Johann Spies
On Fri, Nov 17, 2000 at 10:01:28AM +0100, Arnaud Vandyck wrote: > "Robert B. Easter" wrote: > > > > > you can't do that with a cursor, but you can use they mysql-ism called a > > > limit clause. for example, to fetch rows 26-50 from that query, you'd > > > do: > > > > > > select * from films lim