[SQL] Re: Compiling "C" Functions

On Thu, Dec 28, 2000 at 09:36:57AM -0500, Ron Peterson wrote: > Tulio Oliveira wrote: > > > > I appreciate any "C" Function complete samples, including de command > > line for > > the compiler. > > I've attached a generic GNU make snippet for compiling .so files. > Adjust to suite your tastes.

Re: [SQL] Error ??

Tubagus Nizomi <[EMAIL PROTECTED]> writes: > NOTICE: get_groname: group 0 not found > getTables(): SELECT failed. Explanation from backend: 'pqReadData() -- > backend closed the channel unexpectedly. I think you dropped a user that was still a member of a group, or a group still referred to in

[SQL] Error ??

Hello, i have an error : NOTICE: get_groname: group 0 not found getTables(): SELECT failed. Explanation from backend: 'pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. what ca

Re: [SQL] Urgent help

I suspect you have a group with a dangling reference to a deleted user. What do you get from "select * from pg_user" and "select * from pg_group" ? regards, tom lane

Re: [SQL] underscore problem

if your table is table name is case sensitive, you should double quota it, since postgres take lower case as default. Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipi

Re: [SQL] Debug messages in beta5

Kyle <[EMAIL PROTECTED]> writes: > These were interesting too: I'm not sure what to make of them: > NOTICE: Adding missing FROM-clause entry for table "cont_group_link" > ERROR: Rule WHERE condition may not contain references to other > relations > NOTICE: Adding missing FROM-clause entry for

Re: [SQL] DLookup('field', 'table', ['condition'])

Mr. Ambos, > Is this supposed to give effectively the same result as the subquery > (select student.id where name='Bill Gates' limit 1)? I don't think > that subquery is supported in 7.0, but will be in 7.1 along with > EXECUTE for plpgsql which should let you build a query out of the > parts yo

[SQL] Debug messages in beta5

Maybe this will help in evaluating beta5.  Here is some debug output from serverlog while the system was doing a restore to 7.1b5 from a pg_dump file created on a 7.0.3 box: DEBUG:  MoveOfflineLogs: remove 003D DEBUG:  MoveOfflineLogs: remove 003E DEBUG:  MoveOfflineLogs:

Re: [SQL] underscore problem

From: "postgresql" <[EMAIL PROTECTED]> > Is there anywhere in the docs that says we should not use an > underscore in a table name? > > select acode from FC_Client_Info where jobno = '1234'; > fails with a warning that fc_client_info does not exist > notice the lower case. If I quote the table >

[SQL] underscore problem

Is there anywhere in the docs that says we should not use an underscore in a table name? table FC_Client_Info exists with a record where jobno 1234 has info: select acode from FC_Client_Info where jobno = '1234'; fails with a warning that fc_client_info does not exist notice the lower case. I