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!
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:33:22.746217+01 | 2009-12-09 11:33:12 (1 row) Time: 21,010 ms regards Pavel Stehule 2009/12/9 sergey kapustin : > 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! > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[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 state :58P01" Is this error related to the difference of versions ? Thanks in advance.
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/pageinspect": No such file or > directory > SQL state :58P01" > Pageinspect is a contrib-modul, so i think, you should install that. But i don't know if this available for 8.2. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
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, OUT level integer, OUT fastroot integer, OUT fastlevel integer) RETURNS record AS '$libdir/pageinspect', 'bt_metap' LANGUAGE c STRICT; " Can I comment those lines to remove the error ? 2009/12/9 A. Kretschmer > 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/pageinspect": No such file or > directory > > SQL state :58P01" > > > > Pageinspect is a contrib-modul, so i think, you should install that. But > i don't know if this available for 8.2. > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
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 magic integer, OUT version integer, > OUT root integer, OUT level integer, OUT fastroot integer, OUT fastlevel > integer) RETURNS record > AS '$libdir/pageinspect', 'bt_metap' > LANGUAGE c STRICT; > " > > Can I comment those lines to remove the error ? Sure. But that don't solve your problem if you call that function later... Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
