On 01/02/2011 6:50 PM, Steve White wrote:
Hi again, all,
OK I think I now know what the misunderstanding is.
[Please don't top-post. Rearranged for clarity.]
Steve White wrote:
On 1.02.11, Tom Lane wrote:
Steve White writes:
It would be really nice to have a way to load script (especia
MS SQL server 2008 has no problem with this:
select * from client where CLIENT_ID = 12AND SNAME='Smith'
Returns the expected row.
PostgreSQL 9.0 has no problem with it either, again throwing no error
and returning the expected result.
Regards,
Gary.
On 30/10/2010 7:23 PM, Tom Lane wrote:
G
Stefan Kaltenbrunner wrote:
[EMAIL PROTECTED] wrote:
I have just installed Postgres 8.3.1.
And /usr/local/etc/rc.d/postgresql and
/contrib/start-scripts/freebsd scripts are different
BUG in installator?
the one in /usr/local/etc/rc.d/postgresql is likely the on that freebsd
supplies if you
gnp yadav wrote:
The following bug has been logged online:
Bug reference: 3941
Logged by: gnp yadav
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Ubuntu Linux
Description:Insert Error
Details:
CREATE TABLE sentence
(
sentence_id seri
Tom Lane wrote:
Would those of you with access to other DBMSes try this:
create table tab (col integer);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
insert into tab values(1);
insert into tab values(2);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
I claim that a SQL-c
On 4 Sep 2004 at 18:18, Tom Lane wrote:
> "Gary Doades" <[EMAIL PROTECTED]> writes:
> > I have a problem with permissions on sequences when restored to
> > another PC.
>
> This is not a dump/restore bug, because in fact you would have had the
> same beh
Using PostgreSQL 7.4.2 on Fedora core 2
I have a problem with permissions on sequences when restored to another PC. I cannot
find this specific bug reported.
I have a database with lots of tables & sequences with no problems. I have taken a
dump of this database and restored onto another PC (s
