Re: [SQL] How to figure out when was a table created

Well, in certain filesystems you can have the birth time (like ufs2) stored in the inode struct. So you find the file name in your $PGDATA/base directory using the oid of your table (in pg_class), and then you open that file with stat (2) or utimes (2) (or from perl) to read creation data. All t

Re: [SQL] output

      I am using libpg inside a plugin. For oracle conections i can read the server output with this package dbms_output.read_line (... ).    For pgsql is something similar for reading server output ?   Tom Lane wrote: Popeanga Marian <[EMAIL PROTECTED]> writes: Now if i don't us

Re: [SQL] Creating Index

Hi! I thought I have got no more question in this thread, and I was wrong :-( Is the extra 300ms in UNION essential? Best Regards, CN --This table contains 1036 rows. CREATE TABLE table1 ( c1 VARCHAR(20) PRIMARY KEY, c2 "char" )WITHOUT OIDS; - --This table contains 9429 row

Re: [SQL] Creating Index

> The reason why view1 isn't well optimized is that you've been sloppy > about datatypes. It looks to me like the "SELECT CASE" business yields > NUMERIC while the other arm of the UNION yields INTEGER for table4.c3. > For various subtle semantic reasons we do not try to push down > conditions int

[SQL] How to figure out when was a table created

Hi folks, I posted this question a few days ago and got no response so I guess it cannot be done (surprising!) So that leaves me with my business problem. We create a table for each days activity. After N days (typically 7 days) we can drop the table. The table name is not known so cannot force b

[SQL] inherited indexes

Hi I had a use for table inheritance then I noticed the comments in the interactive docs which say that because indexes aren't inherited with tables that the feature is pretty useless. Can anyone tell me if that's fixed in 7.4, and if not when it may be? Thanks Ritchie ---

Re: [SQL] Creating Index

"CN" <[EMAIL PROTECTED]> writes: > I thought since both > SELECT * FROM view1 WHERE year > 2003 > and > SELECT * FROM view2 WHERE year > 2003 > returns 0 rows, subquery in view1 should consume no CPU and thus both > queries should consume roughly the same amount of time. The reason view1 is a lot

Re: [SQL] Creating Index

Greetings! Stephan, > So, in practice you'll actually be doing queries with equality rather than ranges? I'm so glad being understood :-) > > There is still one thing I don't know why - query on view1 being > > extermely slow. I also removed the subquery > > from view1 to form view2. The query o

Re: [SQL] Creating Index

On Thu, 2 Oct 2003, CN wrote: > I am trying to explain the meaning of tables and views: > The tables in the first SELECT in the UNION of view1 are jorunal, whose > rows are entered daily. > The table in the second SELECT in the UNION of view1 is budget, whose > rows use year+month as key. > View1

Re: [SQL] output

Popeanga Marian <[EMAIL PROTECTED]> writes: > Now if i don't use psql from where i can read the output ? If you're using libpq directly, you can install a notice processor hook routine to catch NOTICE messages. Otherwise they go to stderr. regards, tom lane -

Re: [SQL] help with rule and notification

ok if the only info I can pass is that the notify happened and then I need to go look at the notifying table is it possible to create a rule that on update of jobstable insert into notifytable the jobnumber has there been any real discussion about adding this to the todo list? I was really pretty

Re: [SQL] output

On Thursday 02 October 2003 12:09, Popeanga Marian wrote: > > Inside a plpgsql block . > RAISE NOTICE ''Operation performed!''; > > Now if i don't use psql from where i can read the output ? Ah - I think you need to set CLIENT_MIN_MESSAGES accordingly and then you can check for a non-fatal

Re: [SQL] Creating Index

Stephan and Tom, Many thanks! I am trying to explain the meaning of tables and views: The tables in the first SELECT in the UNION of view1 are jorunal, whose rows are entered daily. The table in the second SELECT in the UNION of view1 is budget, whose rows use year+month as key. View1 unions journ

Re: [SQL] output

Richard Huxton wrote: On Thursday 02 October 2003 09:52, Popeanga Marian wrote: Hello all, I am interested on how can i put output data for debugging purposes. Any sample will be very good! Output what data when? To what? If you can describe your situa

Re: [SQL] output

On Thursday 02 October 2003 09:52, Popeanga Marian wrote: > Hello all, > > > I am interested on how can i put output data for debugging > purposes. Any sample will be very good! Output what data when? To what? If you can describe your situation, I'm sure we can come up with somethin

[SQL] output

Hello all, I am interested on how can i put output data for debugging purposes. Any sample will be very good! Thanks, /Marian ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]