[GENERAL] User defined function weirdness

Hi On postgresql 6.4.2 running on digital unix 4.0d. This bit of code - pfunc.c--- /* cc -c -I/usr/local/pgsql/include pfunc.c ld -shared -expect_unresolved '*' -o pfunc.so pfunc.o cc -o pfunc -I/usr/local/pgsql/include pfunc.c create function int10() returns int4 as '/p

[GENERAL] Unique indices and inheritance

Greetings. In the following situation: create table foo (id int4); create table bar (val int4) inherits(foo); Is it possible to create a unique index such that no record in either foo or bar (in other words, in foo*) has a duplicated id? I tried what seemed to be most obvious to

Re: [GENERAL] Re: [SQL] sql 92 support in postgres

Hi! On Thu, 25 Mar 1999, Ross J. Reedstrom wrote: > As to mySQL, I've never used it, but I understand it's a very fast, but I had some experience with MySQL, and yes - it is very fast. > limited, subset of SQL. The biggest drawback I see referenced is the > lack of transaction support. W

[GENERAL] Are postgreSQL views UPDATEable?

Hello, Found this snippet in a postgreSQL GENERAL posting: >Ross J. Reedstrom <[EMAIL PROTECTED]> wrote > >Eric - >I've redirected your question to the general list, since it seems to fit >in there better than the sql list. I think you're confusing mySQL's >limitations with those of PostgreSQL

[GENERAL] using Oids to retrieve a row

anyone know if it is possible to INSERT a row , "save" the oid for this row and subsequently select it based only on the oid ? -- ~~ David O'Farrell AerSoft Limited mailto:[EMAIL

RE: [GENERAL] using Oids to retrieve a row

I use the following technique: add sequence to the primary key of the table look up the sequence the primary key insert a record using (including) the primary key re-query the newly inserted record using the primary key Thanks, Michael -Original Message- From: David O'F

Re: [GENERAL] Are postgreSQL views UPDATEable?

Stuart Rison wrote: > > Hello, > > Found this snippet in a postgreSQL GENERAL posting: > > >Ross J. Reedstrom <[EMAIL PROTECTED]> wrote > > > >[PostGreSQL does] support views, has for quite a while. They're even updateable. > ^^^ > Wha

Re: [GENERAL] using Oids to retrieve a row

are you doing this in psql? Or perl, php, or some other? perl and php both have methods for getting the oid of the last inserted row (use "$oid = $sth->{'pg_oid_status'};" in perl and "$oid = pg_GetLastOid($result_id);" in php ) Look at the php documentation, or do 'perldoc DBD::Pg' to see mor

[GENERAL] ERROR: ExecInitIndexScan

I'm using Postgresql 6.3.2 on Linux RedHat 5.2. I receive the following error when I send a specific query to Postgres: ERROR: ExecInitIndexScan: both left and right op's are rel-vars The query is: select codice,descrizione,sub_titolo, immobili_per_zona.numero_annunci_immobili_vendita,c

[GENERAL] Re: info on people running postgre

Hi We are using PostgreSQL for an extranet project. About one hundred small firms will have a Linux server, and their own intranet (Apache, PostgreSQL, Perl CGI using DBI). On a once a day basis, each linux box connects to a central server (same config) and makes an update. The update is triple: