[ADMIN] how to take a single table data backup in postgres 7.2.3 database.?

2003-09-25 Thread Somasekhar Bangalore
Hi , I would appreciate if some one could help me how to take a single table back up in postgres 7.2.3. Thanks in Advance. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, I

Re: [ADMIN] how to take a single table data backup in postgres 7.2.3 database.?

2003-09-25 Thread Vasilis Ventirozos
On Thursday 25 September 2003 12:01, you wrote: > Hi , > > I would appreciate if some one could help me how to take a sin pg_dump -t tablename dbname ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] Actual function name

2003-09-25 Thread Gaetano Mendola
Hi all, is there a way to know the name of current function, somethink like $0 for a shell script ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to

Re: [ADMIN] Actual function name

2003-09-25 Thread Peter Eisentraut
Gaetano Mendola writes: > is there a way to know the name of current function, > somethink like $0 for a shell script ? In a C function, you can get the OID of the function from fcinfo->flinfo->fn_oid. From that you can get the name and the argument types. -- Peter Eisentraut [EMAIL PROTECTE

Re: [ADMIN] how to take a single table data backup in postgres 7.2.3

2003-09-25 Thread A.Bhuvaneswaran
> I would appreciate if some one could help me how to take a single table > back up in postgres 7.2.3. $ pg_dump -h hostname dbname -t tablename -uf filename.sql regards, bhuvaneswaran ---(end of broadcast)--- TIP 6: Have you searched our list arc

Re: [ADMIN] Actual function name

2003-09-25 Thread Gaetano Mendola
Peter Eisentraut wrote: > Gaetano Mendola writes: > > >>is there a way to know the name of current function, >>somethink like $0 for a shell script ? > > > In a C function, you can get the OID of the function from > fcinfo->flinfo->fn_oid. From that you can get the name and the argument > types.

[ADMIN] pg_dump & SQL statements

2003-09-25 Thread Naomi Walker
I regularly need to unload some rows from tables, and load into different databases, sometimes on different hosts. In simple cases, I can do something like: psql -At -d dbname -c "select from table where" Due to some embedded tabs and other anomalies in our data, we then have t

[ADMIN] Please help (backup -restore)

2003-09-25 Thread Pravas Ray
(B (B (BDear Sir, (BI need your help. I am (Bnew to  postgresql 7.3.2 .   My requirement is row level (Bincermental backup with image & movies (datatype (Bbytea).   Ex: I have tables say sports,music,film. In (Ball those tables I have test data aswell as bytea data(image & (Bmovie). 

[ADMIN] Case Insensitive comparison

2003-09-25 Thread George A.J
hai   i am using postgresql 7.3.x. I am converting a database in MS SQL server to PostgreSQL.   The main problems i am facing is that in sql server the text comparisons are case insensitive. how can i compare text case insensitive in postgresql without using an upper() or lower() function in both

Re: [ADMIN] Case Insensitive comparison

2003-09-25 Thread Donald Fraser
- Original Message - From: George A.J To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 4:39 AM Subject: [ADMIN] Case Insensitive comparison >hai > >i am using postgresql 7.3.x. I am converting a database in MS SQL server to PostgreSQL. > >The main problems i am facing is that in

[ADMIN] ERROR: tuplestore: write failed

2003-09-25 Thread Rhaoni Chiu Pereira
Hi list, What does this error mean ? ERROR: tuplestore: write failed I was just running a SQL and it gave me this error ! Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 --

Re: [ADMIN] Case Insensitive comparison

2003-09-25 Thread scott.marlowe
Any chance of those libs being put somewhere public (gborg.postgresql.org or something?) On Thu, 25 Sep 2003, Donald Fraser wrote: > > - Original Message - > From: George A.J > To: [EMAIL PROTECTED] > Sent: Thursday, September 25, 2003 4:39 AM > Subject: [ADMIN] Case Insensitive compari

Re: [ADMIN] Case Insensitive comparison

2003-09-25 Thread Donald Fraser
Ok I will have a look at how to put it on gborg. Regards Donald Fraser - Original Message - From: "scott.marlowe" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 6:34 PM Subject: Re: [ADMIN] Case Insensitive

Re: [ADMIN] ERROR: tuplestore: write failed

2003-09-25 Thread Rhaoni Chiu Pereira
I already found the error ( out of disk space ) query result too big ! Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 Citando Rhaoni Chiu Pereira <[EMAIL PROTECTED]>: <> <> Hi list, <> <> <>What does this er

Re: [ADMIN] Case Insensitive comparison

2003-09-25 Thread Donald Fraser
Ok I have started the process... I now have to wait for GBorg to get back to me on whether they want it on the site our not. Regards Donald Fraser - Original Message - From: "Jamie Lawrence" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 7:0

[ADMIN] invalid page header

2003-09-25 Thread Hornyak Laszlo
Hi folks! I have a problem again, now with PostgreSQL 7.3.4. One of my 1.8 million rows tables have damaged, it operated all the day and now it is off, we don`t know the reason. When we try to dump or select from it, it says 'Invalid page header in block 12345 in prep'. Does anybody know how to

[ADMIN] Postgresql going to sleep?

2003-09-25 Thread Raj Mathur
I'm consistently getting into a situation where the database client just goes to sleep in a query after some number of queries in quick succession. Using PostgreSQL 7.2.3 on Red Hat Linux 8.0. The postgres process shows up as ``idle in transaction'' in a ps. Are there any tools I can use to figur

[ADMIN] Case Insensitive Test

2003-09-25 Thread Donald Fraser
The Case Insensitive Text data type for PostgreSQL is now part of the GBorg projects.   http://gborg.postgresql.org/project/citext/projdisplay.php   Regards Donald Fraser

Re: [ADMIN] Case Insensitive Test

2003-09-25 Thread Manuel Sugawara
"Donald Fraser" <[EMAIL PROTECTED]> writes: > The Case Insensitive Text data type for PostgreSQL is now part of > the GBorg projects. > > http://gborg.postgresql.org/project/citext/projdisplay.php Nice work, just two comments (1) the C++ comment style (//) is not portable for C programs and shou

Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Donald Fraser
- Original Message - From: "Manuel Sugawara" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 11:12 PM Subject: Re: [ADMIN] Case Insensitive Test > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > > The Case I

Re: [ADMIN] Case Insensitive Test

2003-09-25 Thread Manuel Sugawara
"Donald Fraser" <[EMAIL PROTECTED]> writes: > > Nice work, just two comments (1) the C++ comment style (//) is not > > portable for C programs and should be changed and (2) the standard way > > Fair comment but since it has to be compiled against a valid > PosgtreSQL distribution, which all requi

Re: [ADMIN] Case Insensitive Test

2003-09-25 Thread Donald Fraser
- Original Message - From: "Manuel Sugawara" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 12:28 AM Subject: Re: [ADMIN] Case Insensitive Test > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > > > Nice work,

Re: [ADMIN] invalid page header

2003-09-25 Thread Tom Lane
Hornyak Laszlo <[EMAIL PROTECTED]> writes: > I have a problem again, now with PostgreSQL 7.3.4. One of my 1.8 million > rows tables have damaged, it operated all the day and now it is off, we > don`t know the reason. When we try to dump or select from it, it says > 'Invalid page header in block 123

Re: [ADMIN] Postgresql going to sleep?

2003-09-25 Thread Tom Lane
Raj Mathur <[EMAIL PROTECTED]> writes: > I'm consistently getting into a situation where the database client > just goes to sleep in a query after some number of queries in quick > succession. Using PostgreSQL 7.2.3 on Red Hat Linux 8.0. The > postgres process shows up as ``idle in transaction'' i

Re: Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: >> Nice work, just two comments (1) the C++ comment style (//) is not >> portable for C programs and should be changed and (2) the standard way > Fair comment but since it has to be compiled against a valid PosgtreSQL > distribution, which all require GN

Re: Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Larry Rosenman
--On Thursday, September 25, 2003 20:43:36 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: "Donald Fraser" <[EMAIL PROTECTED]> writes: Nice work, just two comments (1) the C++ comment style (//) is not portable for C programs and should be changed and (2) the standard way Fair comment but since it h

Re: Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: >> We have several beta testers who keep us honest on exactly this point; >> they use compilers that do not take //. Personally I wish gcc could >> be configured not to have these little non-ANSI-isms ... > Actually, I *THINK* C99 allows // comments, but

Re: Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Tom Lane
"Chad R. Larson" <[EMAIL PROTECTED]> writes: > I suspect that among the conformance switches, you can find a combination > you like: I've been through them. None of 'em turn off // comments. Or #-sign preprocessor assertions, or a few other post-ANSI-C inventions. (Hell, preprocessor assertions

Re: Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Stephan Szabo
On Fri, 26 Sep 2003, Tom Lane wrote: > "Chad R. Larson" <[EMAIL PROTECTED]> writes: > > I suspect that among the conformance switches, you can find a combination > > you like: > > I've been through them. None of 'em turn off // comments. Or #-sign On at least some versions of gcc it looks like

Re: Fw: [ADMIN] Case Insensitive Test

2003-09-25 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: >> I've been through them. None of 'em turn off // comments. Or #-sign > On at least some versions of gcc it looks like --std=c89 turns them off Hmm, I haven't tried that in particular. I wonder what else it does? > We don't appear to compile with the