[ADMIN] unsubsribe

2003-09-12 Thread suresh prasanna
unsubsribe pgsql-admin __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[ADMIN] Problem with Sequences

2003-09-12 Thread Markus Espenhain
Hello all, I am new here... I have a Problem by one of our Applications. The Frontend ist an Access-Application who connects through ODBC to the postgres-database (7.3.2). Two of the three Applications works fine. The other have possibly an Problem with Sequences. The Problem is the folowing:

Re: [ADMIN] Row locking during UPDATE

2003-09-12 Thread Andrew Sullivan
I didn't see any response to this. Sorry if this is already stale for you. On Thu, Sep 04, 2003 at 08:21:17AM -0400, David F. Skoll wrote: > Questions: > > 1) Am I on the right track? Is this how PostgreSQL works? More or less, yes. The significant part here is that the postmaster won't notic

Re: [ADMIN] Row locking during UPDATE

2003-09-12 Thread David F. Skoll
On Fri, 12 Sep 2003, Andrew Sullivan wrote: > More or less, yes. The significant part here is that the postmaster > won't notice that the client is gone until it returns from the work > it was trying to do. It'll eventually come back, but it'll take some > time. How low does your contention nee

Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-12 Thread Tom Lane
pginfo <[EMAIL PROTECTED]> writes: > In my pg log I can find: > ERROR: Invalid page header in block 5604 of a_acc You have a corrupt table. Can you drop and recreate a_acc? > before this error I see also : > FATAL: Database "template0" is not currently accepting connections > ERROR: Relation

Re: [ADMIN] Problem with Sequences

2003-09-12 Thread Tom Lane
Markus Espenhain <[EMAIL PROTECTED]> writes: > On user who works with the Database create an new record and save this. > Here the record becomes an ID and another Number from an two sequences. > One other user ist in this moment working with the database and create an new > record, too. > Now he

[ADMIN]

2003-09-12 Thread Jason Alan Smith
unsubscribe pgsql-admin ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-12 Thread pginfo
Hi, Tom Lane wrote: > pginfo <[EMAIL PROTECTED]> writes: > > In my pg log I can find: > > ERROR: Invalid page header in block 5604 of a_acc > > You have a corrupt table. Can you drop and recreate a_acc? > Yes I can.The problem is that it is happen for 4 times in this week. It is happen on 2 d

Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-12 Thread Tom Lane
pginfo <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> You have a corrupt table. Can you drop and recreate a_acc? > Yes I can.The problem is that it is happen for 4 times in this week. Oh? Perhaps you should be looking at the contents of the complained-of pages to try to see what's going on.

Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-12 Thread pginfo
Tom Lane wrote: > pginfo <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> You have a corrupt table. Can you drop and recreate a_acc? > > > Yes I can.The problem is that it is happen for 4 times in this week. > > Oh? Perhaps you should be looking at the contents of the complained-of > pages

[ADMIN] object creation date

2003-09-12 Thread Marie G. Tuite
How can I identify table creation date as opposed to last modified? Thanks. -Marie ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-12 Thread scott.marlowe
On Fri, 12 Sep 2003, pginfo wrote: > Hi, > I am runing linux red hat 7.3 (standart install) > on dual athlon box , 1 GB ram and pg 7.3.4. > > If I try to access with pgAdmin one from my tables (i contains ~ 1 M > records) > the linux box crashes. WAIT. Do you mean you get a kernel panic? Or th

[ADMIN] timestamp with timezone

2003-09-12 Thread Shankar K
Folks, Our databases stores most of the dates as timestamp with timezone format, so the data looks like this... 09/12/2003 12:51:31.268 PDT 09/12/2003 12:50:20 PDT some has centiseconds in them along with TZ. Now i'm wondering is there a way to just extract date and timestamp alone leaving the c

Re: [ADMIN] timestamp with timezone

2003-09-12 Thread Shankar K
oops forgot to mention, database version is 7.3.2 --- Shankar K <[EMAIL PROTECTED]> wrote: > Folks, > > Our databases stores most of the dates as timestamp > with timezone format, so the data looks like this... > > 09/12/2003 12:51:31.268 PDT > 09/12/2003 12:50:20 PDT > > some has centiseconds

Re: [ADMIN] object creation date

2003-09-12 Thread Peter Eisentraut
Marie G. Tuite writes: > How can I identify table creation date as opposed to last modified? Not unless you keep track of it yourself. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[ADMIN] Casting varchar to bytea

2003-09-12 Thread Dylan Milks
Hi. Could someone please tell me how to convert a "varchar" to a "bytea" datatype. I have a column which contains a number stored as a varchar. I have another column of type bytea. I'm trying to insert the value of the varchar column in the bytea column, but the conversion won't work. Somethin

Re: [ADMIN] object creation date

2003-09-12 Thread Terry Hampton
Hello Marie, In most of my tables, I have the same two columns: lastupdateTIMESTAMP not null default ('now'::text)::timestamp(8), createdateTIMESTAMP not null default ('now'::text)::timestamp(8) "crea

Re: [ADMIN] Row locking during UPDATE

2003-09-12 Thread Andrew Sullivan
On Fri, Sep 12, 2003 at 09:53:47AM -0400, David F. Skoll wrote: > > Note that if you do > > this very frequently, and you have also to select the summary data, > > it won't work (as I have learned from painful experience) because > > the holding table will gradually build up a lot of dead tuples. >

Re: [ADMIN] Casting varchar to bytea

2003-09-12 Thread Ian Barwick
On Friday 12 September 2003 20:39, Dylan Milks wrote: > Hi. Could someone please tell me how to convert a "varchar" to a "bytea" > datatype. > > I have a column which contains a number stored as a varchar. I have another > column of type bytea. I'm trying to insert the value of the varchar column >

Re: [ADMIN] Casting varchar to bytea

2003-09-12 Thread Dylan Milks
Thanks, that helped. This is what we did: (to encode VARCHAR -> BYTEA) update webuser set ccnum = decode(ccnumstring, 'escape') where userid=userid (to decode BYTEA -> VARCHAR) select encode(ccnum, 'escape') from webuser But what about decrypting with the AES encryption algorithm? Dylan -O

[ADMIN] unsubscribe

2003-09-12 Thread Héctor A. Albospino
    <>BEGIN:VCARD VERSION:2.1 N:Albospino;Héctor A. FN:Héctor A. Albospino EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20030912T205149Z END:VCARD ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] timestamp with timezone

2003-09-12 Thread Tom Lane
Shankar K <[EMAIL PROTECTED]> writes: > some has centiseconds in them along with TZ. Now i'm > wondering is there a way to just extract date and > timestamp alone leaving the centisecods as well the TZ > part. You mean you want to round off to even seconds? Try date_trunc, or cast to "timestamp(

Re: [ADMIN] timestamp with timezone

2003-09-12 Thread Shankar K
> You mean you want to round off to even seconds? Try > date_trunc, > or cast to "timestamp(0) with time zone". well, i just need to trunc whatever thats after the timestamp i.e from 06/10/2003 12:50:19.188 PDT, i need to remove .188 PDT i'll see if date_trunc helps me or not. thanks for the s

[ADMIN] table-column relation

2003-09-12 Thread Shankar K
Hi, does anybody know the internal pg_ tables that has table/column definitions defined (similar to user_tab_columns in oracle) thanks, Shankar __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---