[ADMIN] Unable to Insert Row

2011-05-02 Thread Sam Stearns
Howdy, Environment: Postgres 8.3.14 Solaris 10 When attempting to insert a row, the following error is received: ERROR: could not open relation with OID 926167091 This OID does not exist anywhere in the database. Most inserts on this table are successful. It is only for 2 particular id's wh

Re: [ADMIN] simple question about using an empty string building a partial index

2011-05-02 Thread Guillaume Lelarge
On 05/03/2011 05:52 AM, Tom Hartnett wrote: > can it be done? > > create index my_idx on my_table(col1) where col1=''; > > ERROR: invalid input syntax for integer: "" > > Seems simple enough but I don't know what the trick is. > col1 is an integer, not a string. And you cannot check for empty

[ADMIN] simple question about using an empty string building a partial index

2011-05-02 Thread Tom Hartnett
can it be done? create index my_idx on my_table(col1) where col1=''; ERROR: invalid input syntax for integer: "" Seems simple enough but I don't know what the trick is.

Re: [ADMIN] OID for pg_get_functiondef

2011-05-02 Thread Raghavendra
On Mon, May 2, 2011 at 10:53 PM, Thomas Kellerer wrote: > jtke...@verizon.net wrote on 02.05.2011 18:52: > > I've just started working on an 8.4 database and I have been asked to >> extract all the functions source code stored in various databases and >> schemas so they can be put into a reposi

Re: [ADMIN] OID for pg_get_functiondef

2011-05-02 Thread Thomas Kellerer
jtke...@verizon.net wrote on 02.05.2011 18:52: I've just started working on an 8.4 database and I have been asked to extract all the functions source code stored in various databases and schemas so they can be put into a repository for the developers. I'm planning to use pg_get_functiondef(OID

Re: [ADMIN] OID for pg_get_functiondef

2011-05-02 Thread Raghavendra
select oid,proname from pg_proc where proname='function-name'; Best Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Mon, May 2, 2011 at 10:22 PM, wrote: > I've just started working on an 8.4 database and I have been asked to > extract all the functions sour

[ADMIN] OID for pg_get_functiondef

2011-05-02 Thread jtkells
I've just started working on an 8.4 database and I have been asked to extract all the functions source code stored in various databases and schemas so they can be put into a repository for the developers. I'm planning to use pg_get_functiondef(OID) but I am having a hard time finding the OID for

Re: [ADMIN] Postgres TimeZone

2011-05-02 Thread Kevin Grittner
"Anibal David Acosta" wrote: > In my country we have daylight saving so my windows OS is > configured to automatically change timezone but the postgres only > reload the new timezone after restart. Can you show us your settings? http://wiki.postgresql.org/wiki/Server_Configuration You're n

[ADMIN] Postgres TimeZone

2011-05-02 Thread Anibal David Acosta
Hello, I have a postgres installed on a Windows server machine. In my country we have daylight saving so my windows OS is configured to automatically change timezone but the postgres only reload the new timezone after restart. Is possible to kept the Postgres in sync with the windows time (time a

[ADMIN] Postgresql 8.4 database server

2011-05-02 Thread Hiren Lad
H, i m installing postgresql sillently from client machine using command prompt. Postgresql contains pgadmin tool, which provides GUI tool for table creation, deletion, record manipulation etc. Now if i install postgresql from client machine then they easily retrive the data of database. So is