Re: [HACKERS] [ADMIN] problems with pg_restore

2003-07-19 Thread Kuhn, Dylan K (4520500D)
> Given the current implementation, it seems like there are > three possible > behaviors for COMMENT ON DATABASE when the database name > isn't the same > as the current database: > > 1. Raise error (what we're doing now). Simple but breaks dump scripts >for the restore-into-different-DB s

Re: [HACKERS] dblink_ora - a first shot on Oracle ...

2003-07-19 Thread Hans-Jürgen Schönig
Bruce Momjian wrote: Joe, I can do the configure detection of the Oracle library needed for /contrib. I don't think we follow the beta freeze as much for /contrib stuff, but this particular /contrib is more integrated into the main system than most. If you want to merge it in during the next mont

Re: [HACKERS] backend/parser compile prob

2003-07-19 Thread itojun
>Answer is: a broken flex 2.5.4. There were some commits to NetBSD flex to >use bounded strings. Using 13th July flex source builds a happy PostgreSQL. >Now to track down which bit broke - anyway, not a PostgreSQL problem :-) could you try usr.bin/lex/initscan.c revision 1.16? itojun ---

Re: [HACKERS] backend/parser compile prob

2003-07-19 Thread itojun
>> could you try lex/scan.l 1.13 i just committed? >Yes, that fixed it! tnx for reporting! itojun ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] php with postgres

2003-07-19 Thread Marcus Börger
Hello Jan, Sunday, July 13, 2003, 1:22:09 PM, you wrote: JW> Joe Conway wrote: >> ivan wrote: >>> ok, but php should build this lang for postgres i think >>> so, we should talk with php group ? >> >> I have been talking with several people about this on-and-off for a >> while now. If I can find

Re: [HACKERS] [ADMIN] problems with pg_restore

2003-07-19 Thread Andrew Biagioni
Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: On Tue, Jul 15, 2003 at 04:03:13PM -0400, Tom Lane wrote: Given the current implementation, it seems like there are three possible behaviors for COMMENT ON DATABASE when the database name isn't the same as t

Re: [HACKERS] php with postgres

2003-07-19 Thread Marcus Börger
Hello ivan, Sunday, July 13, 2003, 10:12:43 PM, you wrote: i> what aoubt stream ? i> in plpgsql you can just write command INSERT ... or DELETE i> if you want sht like this in php you need to correct zend i think . i> in php all var is declared as variant type but we need look at realy type. In

Re: [HACKERS] Missing array support

2003-07-19 Thread Bruce Momjian
Joe, do you need a TODO added for this? --- Joe Conway wrote: > Tom Lane wrote: > > Joe Conway <[EMAIL PROTECTED]> writes: > > > >>So array[] should produce '{}' of (an array) type determined by the > >>context? OK -- seem

Re: [HACKERS] Missing array support

2003-07-19 Thread Joe Conway
Bruce Momjian wrote: I guess we should put array-of-UNKNOWN on the list of things to look at for 7.5. Yeah; maybe something like this? Delay resolution of array expression type as long as possible so that assignment coercion can be performed on empty array expressions. Joe ---

Re: [HACKERS] Missing array support

2003-07-19 Thread Bruce Momjian
Added. --- Joe Conway wrote: > Bruce Momjian wrote: > >>I guess we should put array-of-UNKNOWN on the list of things to look at > >>for 7.5. > >> > > Yeah; maybe something like this? > > Delay resolution of array expressi

Re: [HACKERS] Is Patch Ok for deferred trigger disk queue?

2003-07-19 Thread Bruce Momjian
Stuart, were are on this patch? Seems we need GUC additions, though I can do that for you, and changes to write the head to disk. Was that completed? --- Stuart wrote: > Tom Lane wrote: > > > Stephan Szabo <[EMAIL PROTECT

Re: [HACKERS] Updating psql for features of new FE/BE protocol

2003-07-19 Thread Bruce Momjian
Do we have any way of seeing all the predefined psql \set setting? Right now if you do \set, you see the settings for that client, but you don't see a list of setting the psql understands, like autocommit. You can only see those in the psql manual. On the server side, we have SHOW ALL which sh

Re: [HACKERS] dblink_ora - a first shot on Oracle ...

2003-07-19 Thread Bruce Momjian
One reason I am excited about an Oracle-enabled dblink is that it gives us a seamless way for PostgreSQL to operate in an evironment with multiple database products, which I think is important. As far as the Oracle libraries, once you have an Oracle-enabled patch in CVS, I will put a some value i

Re: [HACKERS] CREATE TYPE

2003-07-19 Thread mallah
sorry i was not the rite person to answer at the first place. wait for other hacker to help ya. regds mallah. > OK - i've got the basic input/output working now - but how to I do the > extent bit ? > eg. allow : > > create table ( > something a4gl_datime(15) > ) > > > On Friday 18 July

Re: [HACKERS] dblink_ora - a first shot on Oracle ...

2003-07-19 Thread Joe Conway
Hans-Jürgen Schönig wrote: Thanks a lot. I will integrate named connections as proposed by the most recent version of dblink as soon as possible. Thanks for doing the configure stuff. What we need is Oracle's OCI interface and libsqlora (http://www.poitschke.de/libsqlora8/). I was thinking that w

Re: [HACKERS] plpgsql strangeness with select into

2003-07-19 Thread Philip Warner
At 05:24 PM 18/07/2003 +0200, Reinoud van Leeuwen wrote: Does anyone have a clue what is going wrong? I use Postgresql 7.3.3 on FreeBSD 4.5. Is it a before or after trigger. If 'before', are you trying to reference data that does not exist yet? --

Re: [pgsql-advocacy] [HACKERS] [GENERAL] Postgresql & AMD x86-64

2003-07-19 Thread Bruce Momjian
Manfred Spraul wrote: > Bruce Momjian wrote: > > > if test "$enable_debug" = yes && test "$ac_cv_prog_cc_g" = yes; then > >CFLAGS="$CFLAGS -g" > > fi > >+ > >+ /* Compile AMD Opteron using gcc in 64-bit mode */ > >+ if test "$GCC" = yes; then > >+ case $host in > >+ ia64-*) CFLAGS="$CFLA