Alvaro Herrera wrote:
> Tom Lane wrote:
> > Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > > It would be nice to have this text in HTML or info format. This PDF
> > > mess is really awkward.
> >
> > Yeah, that's why I tend to look at SQL92 or SQL99 first ... I have those
> > drafts in plain-ASCII
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > It would be nice to have this text in HTML or info format. This PDF
> > mess is really awkward.
>
> Yeah, that's why I tend to look at SQL92 or SQL99 first ... I have those
> drafts in plain-ASCII format, which is so much easier to
The expected behavior can be obtained by filtering out the null in
the subquery or by using "not exists" instead of "not in".
Here is an example:
CREATE TEMPORARY TABLE subquerytable (column1 INTEGER);
INSERT INTO subquerytable VALUES(2);
INSERT INTO subquerytable VALUES(NULL);
INSERT INTO subqu
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> It would be nice to have this text in HTML or info format. This PDF
> mess is really awkward.
Yeah, that's why I tend to look at SQL92 or SQL99 first ... I have those
drafts in plain-ASCII format, which is so much easier to grep and copy.
Would love to
Tom Lane wrote:
> I haven't looked at SQL99 or SQL2003, but most likely they say the same
> thing in two or three times as many words ;-)
Thanks for the pointer. In SQL 2003, this is 7.12
:
17) Case:
a) If the i-th in the specifies an
that contains a CN, then the
of the i-th column o
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Or show us where the standard mandates name munging and we
> will implement it.
SQL92 says (in 7.9 ):
9) Case:
a) If the i-th in the specifies
an that contains a C, then the
of the i-th column of t
"RIMBAUD Christophe" <[EMAIL PROTECTED]> writes:
> corio=# begin ;
> BEGIN
> corio=# close PRUTCURSNOLOCK;
> ERROR: cursor "prutcursnolock" does not exist
This is an intentional change. Sorry; you're going to have to fix your
application to not do that.
regards, tom lane
Brandon Black wrote:
> I realize this is fixable by the user with "AS count_x", this is more an
> issue that came in writing cross-vendor ORM modules in perl, where most
> other database vendors offer some sort of unique naming convention, but
> postgres' output column names are indistinguishable,
"" <[EMAIL PROTECTED]> writes:
> pqcomm.c: In function `pq_getkeepalivesidle':
> pqcomm.c:1186: `socklen_t' undeclared (first use in this function)
> pqcomm.c:1186: (Each undeclared identifier is reported only once
> pqcomm.c:1186: for each function it appears in.)
Thanks for the report. socklen_
The following bug has been logged online:
Bug reference: 2205
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: alphaev68-dec-osf5.1a
Description:Compilation error on Tru64: socklen_t in pqcomm.c
Details:
pqcomm.c: In function
dear sir,
1.First Question :Under Linux I Use pg_dump -Ft -h 192.168.0.2 -U dbusername -d db > /home/pgsql/back.tar And Then pg_restore -c -h 192.168.0.2
-U dbusername -d db /home/pgsql/back.tar The Error shows Like this...What Can I Do?? pg_restore: [archiver (db)] Error while PROCESSING TOC:
The following bug has been logged online:
Bug reference: 2206
Logged by: RIMBAUD Christophe
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux Rh3 IA 64
Description:error on declare cursor after a close cursor
Details:
error when i de
The following bug has been logged online:
Bug reference: 2204
Logged by: Brandon Black
Email address: [EMAIL PROTECTED]
PostgreSQL version: All
Operating system: All
Description:Feature Req: Unique output column names
Details:
-Example
Welco
> The following bug has been logged online:
>
> Bug reference: 2188
> Logged by: venkat
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.2
> Operating system: Windows Xp Professional Service Pack 2
> Description:win32 version of 8.1.2 is not getting install
> > The following bug has been logged online:
> >
> > Bug reference: 2182
> > Logged by: Anantha Prasad
> > Email address: [EMAIL PROTECTED]
> > PostgreSQL version: 8.1.2-1
> > Operating system: Win2000 Prof
> > Description:Internal account lookup failure:
> > Details:
15 matches
Mail list logo