Re: [HACKERS] v7.3.1 psql against a v7.2.x database ...

2003-01-11 Thread Christopher Kings-Lynne
> these changes for 7.4 and also release a binary version in the mean time. > I have a copy of a 7.2 psql binary for linux that that has some of the > 7.3 psql improvments in it, sometimes it comes in very handy. I'd be > interested in helping out with this, though Christopher would probably > star

Re: [HACKERS] help with PL/PgSQL bug

2003-01-11 Thread Mike Mascari
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> > "Mike Mascari" <[EMAIL PROTECTED]> writes: > >> Does Oracle's PL/SQL have a concept of record variables? If so, what > >> do they do in this situation? > > > In Oracle 8, a row of NULLs: > > > 1 CREATE OR REPLACE FUNCTION fo

Re: [HACKERS] src/port/fseeko.c revision 1.9 broken on NetBSD

2003-01-11 Thread Bruce Momjian
The change was made because a BSD/OS developer said flockfile was POSIX, and pointed to something that suggested NetBSD supports it. I will back out the change. We really don't need fseeko/ftello to be thread safe anyway.

Re: [HACKERS] pg_rules view

2003-01-11 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > I tried creating a rule like: > create rule "_RETURN" as on select to asfd do instead select * from blah; > And it worked. > But it doesn't appear in pg_rules. That's by design. pg_rules suppresses view rules. You'll find asfd in pg_views, in

Re: [HACKERS] v7.3.1 psql against a v7.2.x database ...

2003-01-11 Thread Robert Treat
On Sat, 11 Jan 2003 03:34:22 -0500, Marc G. Fournier wrote: > On Sat, 11 Jan 2003, Lamar Owen wrote: > >> On Friday 10 January 2003 23:50, Marc G. Fournier wrote: >> > That was the aspect I feared ... almost an argument in itself for why >> > psql should be in gborg as a seperate project ;) >> >>

[HACKERS] pg_rules view

2003-01-11 Thread Christopher Kings-Lynne
I tried creating a rule like: create rule "_RETURN" as on select to asfd do instead select * from blah; And it worked. But it doesn't appear in pg_rules. I created this one: create rule myrule as on insert to asfd do instead nothing; And it does appear: test=# select * from pg_rules ; schem

Re: [HACKERS] v7.3.1 psql against a v7.2.x database ...

2003-01-11 Thread Marc G. Fournier
On Sat, 11 Jan 2003, Lamar Owen wrote: > On Friday 10 January 2003 23:50, Marc G. Fournier wrote: > > That was the aspect I feared ... almost an argument in itself for why psql > > should be in gborg as a seperate project ;) > > You've got to be kidding. The main command-line interface NEEDS to b