Re: [GENERAL] copy from problem

Le 22/12/2010 21:34, Mark Watson a écrit : > Hello all, > (Postgres 8.4.6 Windows) > I am stumped as to why I cannot import this using copy from within pgadmin > (the following table is created in an existing database with an encoding of > WIN1252 and the Postgres server_encoding is UTF8) : > CREAT

Re: [GENERAL] copy from problem

On Wednesday 22 December 2010 12:34:58 pm Mark Watson wrote: > Hello all, > (Postgres 8.4.6 Windows) > I am stumped as to why I cannot import this using copy from within pgadmin > (the following table is created in an existing database with an encoding of > WIN1252 and the Postgres server_encoding

[GENERAL] copy from problem

Hello all, (Postgres 8.4.6 Windows) I am stumped as to why I cannot import this using copy from within pgadmin (the following table is created in an existing database with an encoding of WIN1252 and the Postgres server_encoding is UTF8) : CREATE TABLE test ( col_descr text ) WITH ( OIDS=FALSE )

Re: [GENERAL] Root user commands

On Wednesday 22. December 2010 20.03.23 Bob Pawley wrote: > Hi > > I am attempting to see if my Postgresql installation is running. > > I’ve found this - > [root user only] ./database_service.pl status > > I don’t understand what is meant by root user. > > I also don’t know how “./database_serv

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 10:41 AM, Tom Lane wrote: Adrian Klaver writes: On 12/22/2010 09:03 AM, Tom Lane wrote: I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at all? Alright I am going to show my ignorance here, but why would it not be? $PGDATA/base/1663/26468499 1663 is the

Re: [GENERAL] "could not accept SSPI security context"

Original Message Subject: Re: [GENERAL] "could not accept SSPI security context" From: Reto Schöning To: Brar Piening Date: 22.12.2010 17:08 "The security database on the server does not have a computer account for this workstation trust relationship" [...] Is there anythin

[GENERAL] Root user commands

Hi I am attempting to see if my Postgresql installation is running. I’ve found this - [root user only] ./database_service.pl status I don’t understand what is meant by root user. I also don’t know how “./database_service.pl status” is used. Bob

Re: [GENERAL] How to use pgbouncer

Filip Rembiałkowski wrote: > 2010/12/21 Andreas Kretschmer : > > > > I'm looking for a solution to split read and write access to different > > servers (streaming replication, you know ...). Can i do that with > > pgpool? (setting backend_weightX=0 or 1)? I have read the doc, but i'm > > not sure

Re: [GENERAL] could not open relation...No such file or directory

Adrian Klaver writes: > On 12/22/2010 09:03 AM, Tom Lane wrote: >> I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at >> all? > Alright I am going to show my ignorance here, but why would it not be? > $PGDATA/base/1663/26468499 1663 is the pg_default tablespace, which refers

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 07:20 PM, Tom Lane wrote: Sim Zacks writes: FATAL: could not open relation 1663/26468499/1259: No such file or directory I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at all? /var/lib/postgresql/8.2/data/base/26468499 does exist, and there are 1212 files

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 07:20 PM, Tom Lane wrote: Sim Zacks writes: FATAL: could not open relation 1663/26468499/1259: No such file or directory I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at all? /var/lib/postgresql/8.2/data/base/26468499 does exist, and there are 1212 files

Re: [GENERAL] Cannot unsubscribe

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 "William Gordon Rutherdale (rutherw)" wrote: > Clearly something is broken in the system, as it's contradicting itself > by sending me emails but failing to recognise that same email address > when I attempt to unsubscribe. I confirmed that r

Re: [GENERAL] Table inheritance foreign key problem

On Wed, Dec 22, 2010 at 12:32:44AM -0500, Andy Chambers wrote: > Hi, > > One of the caveats described in the documentation for table > inheritance is that foreign key constraints cannot cover the case > where you want to check that a value is found somewhere in a table > or in that table's descend

Re: [GENERAL] could not open relation...No such file or directory

Sim Zacks writes: >>> FATAL: could not open relation 1663/26468499/1259: No such file or >>> directory >> I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at >> all? > /var/lib/postgresql/8.2/data/base/26468499 does exist, and there are > 1212 files in it, but so far all th

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 09:03 AM, Tom Lane wrote: Sim Zacks writes: Our postgresql database stopped working with the error ERROR: could not open relation 1663/26468499/26470404: No such file or directory Does the not connect also apply to starting postgres in single user mode? Same error with single us

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 07:03 PM, Tom Lane wrote: Sim Zacks writes: Our postgresql database stopped working with the error ERROR: could not open relation 1663/26468499/26470404: No such file or directory Does the not connect also apply to starting postgres in single user mode? Same error with single u

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 06:45 PM, Adrian Klaver wrote: On 12/22/2010 08:37 AM, Sim Zacks wrote: On 12/22/2010 06:28 PM, Adrian Klaver wrote: On 12/22/2010 07:59 AM, Sim Zacks wrote: We are using postgresql 8.2.17 on Gentoo Our postgresql database stopped working with the error ERROR: could not open r

Re: [GENERAL] libpq sendQuery -- getResult not returning until all queries complete

On Wed, Dec 22, 2010 at 11:38 AM, Kelly Burkhart wrote: > On Wed, Dec 22, 2010 at 10:19 AM, Merlin Moncure wrote: >> have you ruled out sending all the data you need to send into say, a >> plpgsal function and doing the work there? >> > > Not sure that would do what they need, which is get a list

Re: [GENERAL] could not open relation...No such file or directory

Sim Zacks writes: > Our postgresql database stopped working with the error > ERROR: could not open relation 1663/26468499/26470404: No such file or > directory >> Does the not connect also apply to starting postgres in single user mode? > Same error with single user mode. > postgres --single -D /v

Re: [GENERAL] extra TARGETENTRY when group by function( col )?

"Craig Harris" writes: > does any one know why the SEQSCAN node has TWO TARGETENTRYs? It doesn't stop to notice that the Var is not referenced by any upper nodes in this particular scenario. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgre

[GENERAL] Error when using phpPgAdmin

Hello and thanks for this great application named pgql. I've setup pg on a windows machine and have installed phppgadmin. The phppgadmin php application comes up correctly in a browser but I get an error message when viewing the databases. The apache log shows this: "[Wed Dec 22 10:27:34 2010]

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 08:37 AM, Sim Zacks wrote: On 12/22/2010 06:28 PM, Adrian Klaver wrote: On 12/22/2010 07:59 AM, Sim Zacks wrote: We are using postgresql 8.2.17 on Gentoo Our postgresql database stopped working with the error ERROR: could not open relation 1663/26468499/26470404: No such file or

[GENERAL] extra TARGETENTRY when group by function( col )?

Given: create table t1 ( c1 timestamp without time zone, c2 int ); explain verbose select to_char ( c1, '' ) from t1 group by to_char ( c1, '' ); does any one know why the SEQSCAN node has TWO TARGETENTRYs? Why do we project "c1" as well as "to_char( c1 . )" ?

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 06:28 PM, Adrian Klaver wrote: On 12/22/2010 07:59 AM, Sim Zacks wrote: We are using postgresql 8.2.17 on Gentoo Our postgresql database stopped working with the error ERROR: could not open relation 1663/26468499/26470404: No such file or directory After one minute of these erro

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 06:08 PM, Vick Khera wrote: On Wed, Dec 22, 2010 at 10:59 AM, Sim Zacks wrote: This is our production database and crashed at the end of the day. If possible, I would really not like to lose a full days work by restoring yesterdays backup. So the errors in postgres started after

Re: [GENERAL] could not open relation...No such file or directory

On 12/22/2010 07:59 AM, Sim Zacks wrote: We are using postgresql 8.2.17 on Gentoo Our postgresql database stopped working with the error ERROR: could not open relation 1663/26468499/26470404: No such file or directory After one minute of these errors on every statement run we had what looks lik

Re: [GENERAL] "could not accept SSPI security context"

ok we moved to VS08 and I can at last experiment with the npgsql code. I tried forcing "kerberos" instead of "negotiate" in the call to AcquireCredentialsHandle in SSPIHandler.cs. The exception message I then get in the first call to InitializeSecurityContext() is "The security database on the ser

Re: [GENERAL] could not open relation...No such file or directory

On Wed, Dec 22, 2010 at 10:59 AM, Sim Zacks wrote: > This is our production database and crashed at the end of the day. If > possible, I would really not like to lose a full days work by restoring > yesterdays backup. > So the errors in postgres started after your server crashed? Sounds like the

[GENERAL] could not open relation...No such file or directory

We are using postgresql 8.2.17 on Gentoo Our postgresql database stopped working with the error ERROR: could not open relation 1663/26468499/26470404: No such file or directory After one minute of these errors on every statement run we had what looks like a memory failure: Dec 22 16:37:44 lo

Re: [GENERAL] Cannot unsubscribe

> -Original Message- > From: Adrian Klaver [mailto:adrian.kla...@gmail.com] > Sent: 21 December 2010 20:36 > To: pgsql-general@postgresql.org > Cc: William Gordon Rutherdale (rutherw) > Subject: Re: [GENERAL] Cannot unsubscribe > > On Tuesday 21 December 2010 4:16:00 pm William Gordon Ruth

Re: [GENERAL] Constraining overlapping date ranges

Filip, The period type + exclusion constraint was exactly the avenue I was taking, and I was also perplexed that period was not defined as immutable. Your solution, to force period() to be immutable, seemed like a reasonable one (though it didn't work, see below). I tried implementing this on m

Re: [GENERAL] libpq sendQuery -- getResult not returning until all queries complete

On Wed, Dec 22, 2010 at 9:18 AM, Merlin Moncure wrote: > On Wed, Dec 22, 2010 at 10:07 AM, Kelly Burkhart > wrote: >> On Tue, Dec 21, 2010 at 6:11 PM, Tom Lane wrote: >>> Merlin Moncure writes: On Tue, Dec 21, 2010 at 6:49 PM, Tom Lane wrote: > If you just unconditionally flush there,

Re: [GENERAL] Cannot unsubscribe

On Wednesday 22 December 2010 7:18:00 am William Gordon Rutherdale (rutherw) wrote: > > Unfortunately I haven't a clue what my password is supposed to be. It would have been in the confirmation reply that you got when you signed up, on the off chance you still have it:) > > Clearly something

Re: [GENERAL] libpq sendQuery -- getResult not returning until all queries complete

On Wed, Dec 22, 2010 at 10:07 AM, Kelly Burkhart wrote: > On Tue, Dec 21, 2010 at 6:11 PM, Tom Lane wrote: >> Merlin Moncure writes: >>> On Tue, Dec 21, 2010 at 6:49 PM, Tom Lane wrote: If you just unconditionally flush there, it will result in an extra network message in the normal c

Re: [GENERAL] libpq sendQuery -- getResult not returning until all queries complete

On Tue, Dec 21, 2010 at 6:11 PM, Tom Lane wrote: > Merlin Moncure writes: >> On Tue, Dec 21, 2010 at 6:49 PM, Tom Lane wrote: >>> If you just unconditionally flush there, it will result in an extra >>> network message in the normal case where there's not another query >>> to do.  The current cod

[GENERAL] Unable to write inside TEMP environment variable path

Hi there, I wanted to install postgreSQL on a Windows XP machine, but during the install it says: http://postgresql.1045698.n5.nabble.com/file/n3315027/error.png Anyone knows what to do? The user is an admin, and there is enough free disk space to write for. Thanks in advance. Rens -- View t

Re: [GENERAL] Table inheritance foreign key problem

Richard Broersma writes: > On Tue, Dec 21, 2010 at 9:32 PM, Andy Chambers wrote: >> create table guidebooks ( >> city check (city in (select name >> from cities)), > This is a nice idea. They only problem is that PostggreSQL doesn't > support sub-selects in a tables che

Re: [GENERAL] Constraining overlapping date ranges

2010/12/22 Thomas Kellerer : > I'm curious why you use this syntax as you have fixed values and could use > the "standard" VALUES construct without problems: > > INSERT INTO tbl VALUES (1, '2010-01-01', '2010-12-31'); no particular reason; just two keystrokes less :-) The SQL code is postgres-sp

Re: [GENERAL] Constraining overlapping date ranges

Filip Rembiałkowski, 22.12.2010 14:28: INSERT INTO tbl SELECT 1, '2010-01-01', '2010-12-31'; INSERT 0 1 I'm curious why you use this syntax as you have fixed values and could use the "standard" VALUES construct without problems: INSERT INTO tbl VALUES (1, '2010-01-01', '2010-12-31'); Regards

Re: [GENERAL] Constraining overlapping date ranges

2010/12/21 McGehee, Robert : > PostgreSQLers, > I'm hoping for some help creating a constraint/key on a table such that there > are no overlapping ranges of dates for any id. > > Specifically: Using PostgreSQL 9.0.1, I'm creating a name-value pair table as > such this: > > CREATE TABLE tbl (id IN

Re: [GENERAL] Constraining overlapping date ranges

Le mardi 21 décembre 2010 à 10:49 -0500, McGehee, Robert a écrit : > PostgreSQLers, > I'm hoping for some help creating a constraint/key on a table such that there > are no overlapping ranges of dates for any id. > > Specifically: Using PostgreSQL 9.0.1, I'm creating a name-value pair table as

Re: [GENERAL] Constraining overlapping date ranges

Le mardi 21 décembre 2010 à 10:49 -0500, McGehee, Robert a écrit : > PostgreSQLers, > I'm hoping for some help creating a constraint/key on a table such that there > are no overlapping ranges of dates for any id. > > Specifically: Using PostgreSQL 9.0.1, I'm creating a name-value pair table as

Re: [GENERAL] What Programs Do You Use For PG?

interesting project. do you have any documentation describing how it works? merlin Hi Merlin, Thank you for your interest in the project. Here is how to get it up and running so that you can try out the same application that you see running on: http://173.230.133.34:8080/ 0.