[GENERAL] how to unsubscribe

2005-01-21 Thread Alexander Cohen
How do i unsubscribe from the list? thanks Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] new data types

2004-11-09 Thread Alexander Cohen
When i write code in C to create the functions that define a new data type, how can i set a value so that the user sees a null value from sql. thanks Alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] undefined symbols

2004-10-20 Thread Alexander Cohen
IM trying to build the ppostgres ODBC driver for MacOSX. I thought id try and build it as a bundle from XCode. All compiles no problem but then at the end of the compile i get an undefined symbols error, here it is: ld: Undefined symbols: _CurrentMemoryContext _MemoryContextAlloc _pfree Any ide

[GENERAL] ODBC

2004-10-13 Thread Alexander Cohen
Hi, Im looking for instructions on installing the postgresql ODBC driver on mac osx and windows. Is there any reference for that. Any help is apprecitaed. BTW, i need to compile it and install it wihtout using the windows installer. Alex ---(end of broadcast)

[GENERAL] problem with pg_restore

2004-10-05 Thread Alexander Cohen
I cant seem to get pg_restore to work for me. here's how im calling it: pg_restore -d -C -v -U It keeps on telling me that the database does not exist so it cant connect to it. I thought the -C flag creates the database, what am i missing here? Thanks Alex ---(end of

Re: [GENERAL] error connecting to database

2004-10-01 Thread Alexander Cohen
On 1-Oct-04, at 3:06 PM, Tom Lane wrote: Alexander Cohen <[EMAIL PROTECTED]> writes: Could not connect to server: permission denied. Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432" What exctly does this error message mean? Wha

[GENERAL] error connecting to database

2004-10-01 Thread Alexander Cohen
Im trying to connect locally to a database on a running postgres cluster. If i connect with psql, everything is fine and i can transact. I i try and connect in my own app, i get this error: Could not connect to server: permission denied. Is the server running locally and accepting connections on

[GENERAL] row level grants

2004-07-01 Thread Alexander Cohen
Is there any way to grant user access at the row level? Or maybe some way to simulate it? Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] full tuple count in cursor.

2004-05-09 Thread Alexander Cohen
I have a cursor that i got from a select statement. I would like to know how many records are in the cursor so i dont go over the last one when using FETCH on the cursor. How can i do this? thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443

[GENERAL] list types

2004-05-05 Thread Alexander Cohen
How can i get a list of all types that dont have the "_"before them. I only want a list of the types that a user might need to create tables. thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---(end of

Re: [GENERAL] pgsql folder and its contents

2004-05-02 Thread Alexander Cohen
I understand that, but i still really need some kind of reference on what files do what. Does anything of that sort exist? thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 On May 1, 2004, at 5:01 PM, Peter Eisentraut wrote: Alexander Cohen wrote: Im looking to

[GENERAL] cursor questions

2004-04-20 Thread Alexander Cohen
"SELECT count(cursor_column) FROM cursor_name", but i get a relation does not exist error. thanks. -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---(end of broadcast)--- TIP 3: if posting/reading through Usen

[GENERAL] pg_ctl problem

2004-04-08 Thread Alexander Cohen
r to get the server up and running? thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEm

[GENERAL] How to list domains

2004-04-07 Thread Alexander Cohen
How can i get list of all domains available? thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[GENERAL] type definitions

2004-03-15 Thread Alexander Cohen
Where in the postgres source code can i find the source that declares all the data types that postgres has? Where does it tell postfgres that these types exist ena d here are there functions? thanks -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443

[GENERAL] pg_aggregate weird stuff

2004-03-10 Thread Alexander Cohen
Im trying to get a list of aggregate names. So i do "SELECT aggfnoid FROM pg_aggregate" to get a list of Oid of the functions. But this column seems to return names and not Oid's of the procs. Is this normal, how can i get a loist of proc Oid's for the aggregtates? thanks

[GENERAL] More info on table fields

2004-03-02 Thread Alexander Cohen
Im looking to get a bit of info from a tables column. Im looking for if the column is a primary key, im also looking for the columns constraints and its foreign key reference if it is one. How can i get theses with an SQL query? -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237

[GENERAL] change db encoding

2004-02-26 Thread Alexander Cohen
How would i go about changing a databases encoding? Is this at all possible? There does not seem to be much i can with ALTER DATABASE except change its name! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---(end of broadcast