Re: [SQL] two records per row from query

In response to John : > mytable > pkid > class_date. > sessionid > > select * from mytable > 1 2009/01/01 2101 > 2 2009/01/02 2101 > > I would like an SQL that would produce > > newtable > pkid, > class_date1, > class_date2, > sessionid1, > sessionid2 > > Select * from newtable > > 1 2009/01/0

Re: [SQL] LOG: unexpected EOF on client connection

Bernd Nawothnig writes: > A client application written in C# + npgsql 2.0.6 causes reproducable > log entries like this: > LOG: unexpected EOF on client connection > LOG: could not receive data from client: Die Verbindung wurde vom > Kommunikationspartner zurückgesetzt(*) This just indicates

Re: [SQL] LOG: unexpected EOF on client connection

Hello, A client application written in C# + npgsql 2.0.6 causes reproducable log entries like this: LOG: unexpected EOF on client connection LOG: could not receive data from client: Die Verbindung wurde vom Kommunikationspartner zurückgesetzt(*) (*) Connection reset by peer The responsable Pr

Re: [SQL] Create table command fails with permission denied

Hi Tom, Thanks a lot. What you suspected is correct. Permissions are modified on the underlying OS directory of this database. Once the permissions are rectified, I'm able to create tables without any issues. Thanks to all for your support. Venkat -Original Message- From: Tom Lane [mai

Re: [SQL] Problems when copy data from dump file

-Ursprungligt meddelande- Från: Richard Huxton [mailto:d...@archonet.com] Skickat: den 4 augusti 2009 15:27 Till: Klas Stockhem Kopia: PostgreSQL Ämne: Re: SV: [SQL] Problems when copy data from dump file Klas Stockhem wrote: > Thanks for your mail! Remember to cc: the mailing list too

[SQL] question about pgagent

Hi All, First I will explain what I try to do: I'd like to synchronize more or less two databases, in a third database. I mean, I want to book keep when an object has arrived in both databases. (In one database I am allowed to use trigger function but not in the other) 1) Postgres (maint

[SQL] two records per row from query

mytable pkid class_date. sessionid select * from mytable 1 2009/01/01 2101 2 2009/01/02 2101 I would like an SQL that would produce newtable pkid, class_date1, class_date2, sessionid1, sessionid2 Select * from newtable 1 2009/01/01 2009/01/02 2101 2101 I have a list of classes that is perfect