Re: [SQL] SQL state 58P01 triggered by a database script execution

In response to aymen marouani : > Thanks for the help, > > In deed I found those lines in my script > > "-- > -- TOC entry 25 (class 1255 OID 16409) > -- Dependencies: 6 > -- Name: bt_metap(text); Type: FUNCTION; Schema: public; Owner: postgres > -- > > CREATE FUNCTION bt_metap(relname text, OUT

Re: [SQL] SQL state 58P01 triggered by a database script execution

Thanks for the help, In deed I found those lines in my script "-- -- TOC entry 25 (class 1255 OID 16409) -- Dependencies: 6 -- Name: bt_metap(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION bt_metap(relname text, OUT magic integer, OUT version integer, OUT root integer,

Re: [SQL] SQL state 58P01 triggered by a database script execution

In response to aymen marouani : > Hi, > > I have a database under Postgres v8.3 and I generated its backups script using > PGAdmin III. > I executed the same script under Postgres v8.2 in order to create the same > database but I get the following error > > " ERROR: could not access file "$libdir

[SQL] SQL state 58P01 triggered by a database script execution

Hi, I have a database under Postgres v8.3 and I generated its backups script using PGAdmin III. I executed the same script under Postgres v8.2 in order to create the same database but I get the following error " ERROR: could not access file "$libdir/pageinspect": No such file or directory SQL s

Re: [SQL] Stalled post to pgsql-sql

hello postgres=# create table foo(a timestamp(0)); CREATE TABLE Time: 111,105 ms postgres=# insert into foo values(now()); INSERT 0 1 Time: 1,292 ms postgres=# select now(), a from foo; now | a ---+- 2009-12-09 11:

Re: [SQL] Stalled post to pgsql-sql

Hello, I need a type that will store date and time, but without seconds and microseconds (like timestamp does). At least without microseconds. I also need all the operators to work. Is this possible with one of existing date/time types or i need to create my own? Thank you!