Adam Levine ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
INSERT doesn't like (.)
Long Description
I'm using Dynamo connected to Postgres. The PreparedStatement generated for an INSERT
works on other dbs, but Postgres comp
[EMAIL PROTECTED] writes:
> I'm using Dynamo connected to Postgres. The PreparedStatement
> generated for an INSERT works on other dbs, but Postgres complains
> with a parsing error.
> specifically:
>INSERT into (.) VALUES ();
What's your definition of "other dbs"? The above statement is
> INSERT doesn't like (.)
This isn't allowed by SQL and is completely useless.
::=
INSERT INTO
::=
::=
|
|
::=
[]
[ ]
I think this had been addressed.
> On Mon, Jun 12, 2000 at 05:39:55PM -0400, Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > That was my guess, though his changes were s_lock related. Seems that is
> > > an Alpha mess too.
> >
> > Yes, it sounds like we will need some help f
Hi People,
I have encountered the following problem with pg_dump from postgresql
7.0.2 on linuxppc:
bash $ pg_dump template1 >tp.db
getFuncs(): SELECT failed. Explanation from backend: 'ERROR:
getattproperties: no attribute tuple 1255 -2'.
CONFIGURATION
machine: PowerMac Rev2 B/W G3 450, 256M
I wasn't aware that Postgres accepted regular expressions (they seem
undocumented) until reading the draft of Bruce Momjian's forthcoming
book. However, now having looked at them, I have found a bug in
matching a particular expression from a PostgreSQL database. I am
using:
PostgreSQL 7.0
On Mon, 2 Oct 2000, Stuart Peters wrote:
> \connect - postgres
> CREATE TABLE "bug" (
> "title" text
> );
> COPY "bug" FROM stdin;
> abcdefghijklm
> nopqrstuvwxyz
> aeiou
> \.
>
>
>
> The following queries work as expected, EXCEPT for [2]. I believe
> that [2] and [3] should return
Your name : Suchandra Thapa
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : K6-2
Operating System (example: Linux 2.0.26 ELF) : linux 2.2.17
PostgreSQL version (example: PostgreSQL-7.0): Po
Hello,
I've discovered a bug in the date_part function. It returns 25 when
doing select date_part('day','2000-03-26'::date);
Anyway, this isn't happening if casting the date to timestamp
select date_part('day','2000-03-26'::timestamp);
Alexander
[ Charset ISO-8859-1 unsupported, converting... ]
> Hello,
> I've discovered a bug in the date_part function. It returns 25 when
> doing select date_part('day','2000-03-26'::date);
> Anyway, this isn't happening if casting the date to timestamp
> select date_part('day','2000-03-26'
It appears, the following patch is needed to ensure the 7.0.2 can be
built with SSL support (with OpenSSL). It fixes the fe-connect.c to
report errors in "the new way". A few Makefiles also need to be modified
to ensure the SSL libraries are listed as dependencies for the PG libs.
--- i
I attach bug.template file with description of my problem.
Please fix it asap.
--
Keep in touch.
Sergey Mavrinsky.
Solvo Ltd.
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to [E
The following patch adds --without-tk switch to 7.0.2's configure.
Currently, if the TK is present at build time, it will be linked
in, which makes it more difficult to build on one's workstation and
deploy on the X11-less server, where TCL is still desirable.
This patches let you disable Tk even
The e-mail addresses are listed on the URL in subject in the <...>
notation.
This makes the browser skip them as unknown tags and requires one to
look through the HTML source for addresses. How about < and > ?
Overall, the weblint's output for the page is:
index.php(2): illegal value
I think I have found a bug with Postgres' permissions. I have combed
through the documentation, but I haven't been able to find an explanation
for the following problem.
First of all here is what I am running.
Postgress version 7.0.2 ,
OS Linux Red Hat 6.2
Kernel version 2.2.17
I have the fol
I found a irregular behavior with constraints.
I can only set a referencial integrity between these tables when there are
no data, even if there are no change to referential integrity violation.
Please analyse the following case.
teste=# CREATE TABLE E_2 (
teste(#codigo2 in
HI
I am creating a field in a table as two dimensional array. But pgres is
creating only single dimension array. I verified \d table name . It is
showing table field is single dimensioning only.
please clarify
srinivas
I personally have connected Dynamo against Oracle and MS-SQL w/o fail.
Those 2 systems, as well as SQLanywhere seem to support this syntax. If
this is a non-standard syntax, one might wonder what moved them to support
it. Perhaps in an effort to alias the table as is done on a select?
If t
I don't think this would be of general use for users. Sorry.
> The following patch adds --without-tk switch to 7.0.2's configure.
> Currently, if the TK is present at build time, it will be linked
> in, which makes it more difficult to build on one's workstation and
> deploy on the X11-less serv
It's been discussed a fair bit in the mailing lists but I don't think it's
made the documentation. The triggers use SELECT FOR UPDATE to get the row
locks but that forces the update permission need. In 7.1 this should be
gone (Peter E had a patch to remove the most common cases of this).
Steph
"Alexandru COSTIN" <[EMAIL PROTECTED]> writes:
> I've discovered a bug in the date_part function. It returns 25 when
> doing select date_part('day','2000-03-26'::date);
Is 2000-03-26 a daylight savings changeover day where you live?
If so, this is a known bug that's fixed for 7.1. date_part
It appears this had already been done in the current sources.
> It appears, the following patch is needed to ensure the 7.0.2 can be
> built with SSL support (with OpenSSL). It fixes the fe-connect.c to
> report errors in "the new way". A few Makefiles also need to be modified
> to ensur
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I don't think this would be of general use for users. Sorry.
>> The following patch adds --without-tk switch to 7.0.2's configure.
More to the point, Peter already put in exactly this switch ;-)
regards, tom lane
"Wendel Leibe" <[EMAIL PROTECTED]> writes:
> Here is the problem. If I try to insert a contact record as, "confUser."
> "psql" and my DBI driver for perl fails with a permission error on objects.
> If I give confUser permissions to write to the objects table the statement
> will execute.
Current
Andrew Smith <[EMAIL PROTECTED]> writes:
> I have encountered the following problem with pg_dump from postgresql
> 7.0.2 on linuxppc:
> bash $ pg_dump template1 >tp.db
> getFuncs(): SELECT failed. Explanation from backend: 'ERROR:
> getattproperties: no attribute tuple 1255 -2'.
7.0.* does not
25 matches
Mail list logo
