[HACKERS] Where is the connection info

2004-12-01 Thread Cason, Kenny
In postgres, how do I find out how many connections are allowed per user? Where those connections are stored? Who has the connections? Etc. Kenny Cason [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[HACKERS] Looking for C++ bytea example

2004-08-10 Thread Cason, Kenny
I need a real example of using bytea in the following scenario: 1) A large binary object is located in a C++ memory space obtained through malloc. 2) I want to store it in the database. What exactly does the code look like? Thanks, Kenny ---(end of broadcast)---

[HACKERS] Selecting a specific row

2004-08-04 Thread Cason, Kenny
Is there an easy way to select, say, the 15th row in a table? I can't use a sequence number because rows will sometimes be deleted resulting in the 15th row now being a different row. I need to be able to select the 15th row regardless of whether it is the same 15th row as the last select. Thanks,

Re: [HACKERS] Accessing Specific Schemas

2004-06-29 Thread Cason, Kenny
Sent: Tuesday, June 29, 2004 1:19 PM To: Cason, Kenny Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Accessing Specific Schemas On Tue, Jun 29, 2004 at 12:07:30PM -0700, Cason, Kenny wrote: > I'm having trouble accessing specific schemas and wonder if maybe I > haven't installed someth

[HACKERS] Accessing Specific Schemas

2004-06-29 Thread Cason, Kenny
I'm having trouble accessing specific schemas and wonder if maybe I haven't installed something properly in 7.4.2. Here is what is happening: SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; ERROR: parser: parse error at or near "." This error appears when I try to access ANY specific schema. Help!