Re: [HACKERS] PostgreSQL-R

2002-12-23 Thread Vadim Mikheev
> > It seems that locking tuples via LockTable at Phase 1 is not > > required anymore, right? > > We haven't put those hooks in yet, so the current version is master/slave. So, you are not going to use any LockTable in Phase 1 on master right now but you still need some LockTable in Phase 3 on sla

Re: [HACKERS] about data type id

2002-12-23 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Try: SELECT oid FROM pg_type WHERE typname='text'; Another possibility (as of 7.3) is regression=# select 'int4'::regtype::oid; oid - 23 (1 row) The regtype converter has the advantage that it will recognize any typename construct u

Re: [HACKERS] about data type id

2002-12-23 Thread Christopher Kings-Lynne
Hi Jinqiang, Try: SELECT oid FROM pg_type WHERE typname='text'; You can always make that into a function. Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Jinqiang Han > Sent: Tuesday, 24 December 2002 10:00 AM > To: [EMAIL PROTECTED] > Sub

[HACKERS] about data type id

2002-12-23 Thread Jinqiang Han
hello, Is there a function that I can get type id from type name, such as from 'text' to 25, 'int' to 23. thanks in advance. Jinqiang Han ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] HP-UX shared library installation is incorrect

2002-12-23 Thread Giles Lean
I wrote: > o so far I've only tested with the HP ANSI C compiler on 11.11, not > with gcc or on other HP-UX releases. > > I can test other releases and probably with gcc, but if someone gets > to it before me that would be just fine. I probably won't until the > new year. Today is quie

Re: [HACKERS] v7.3.1 Bundled and Released ...

2002-12-23 Thread Lamar Owen
On Sunday 22 December 2002 14:12, Marc G. Fournier wrote: > Last night, we packaged up v7.3.1 of PostgreSQL, our latest stable > release. RPMs are available for RedHat8 + tcl8.4.1 at ftp://ftp.postgresql.org/pub/binary/v7.3.1/RPMS (once mirrors propagate it will be at the mirrors) Yes, Red Hat

[HACKERS] PostgreSQL Weekly News.

2002-12-23 Thread Lamar Owen
Thanks to those who did the PostgreSQL Weekly news, and submitted it to LinuxToday. This is a great function for the advocacy people! Many Thanks! -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the

Re: [GENERAL] [HACKERS] v7.3.1 Bundled and Released ...

2002-12-23 Thread Bruce Momjian
Greg Copeland wrote: > On Sun, 2002-12-22 at 13:12, Marc G. Fournier wrote: > > Last night, we packaged up v7.3.1 of PostgreSQL, our latest stable > > release. > > > > Purely meant to be a bug fix release, this one does have one major change, > > in that the major number of the libpq library was i

Re: [HACKERS] v7.3.1 Bundled and Released ...

2002-12-23 Thread Greg Copeland
On Sun, 2002-12-22 at 13:12, Marc G. Fournier wrote: > Last night, we packaged up v7.3.1 of PostgreSQL, our latest stable > release. > > Purely meant to be a bug fix release, this one does have one major change, > in that the major number of the libpq library was increased, which means > that ever