Hello,
I am using postgres installed in two different computers, in one I
have to do the queries using quotation marks (select * from "Table")
and in the other I can do select * from Table.
What can I do to disable the use of quotation marks?
Thanks
Daniel Gomes Mendes
-
I'm fairly confused by this...I have a table called 'contact' with a
serial id column, so it automatically has this constraint:
ALTER TABLE contact
ADD CONSTRAINT contact_pkey PRIMARY KEY(id);
Now, I tried several times in 1.8.0 to add the row just by typing new
data in the Edit Table window
Kevin Field wrote:
> One other detail, after it worked I noticed that the ID returned was one
> where there had been a gap in the sequence (i.e., we had entries 1-12
> and 14-24, and the new row had id 13.) This may be because the existing
> entries had been added with explicit id numbers but the
Hi,
So I like the new hierarchy in 1.8.0, but it seems to be missing said
categories of database objects. Is it planned for them to come back? I
found I actually needed to use those two in particular yesterday and had
to go back and use 1.6.3.
Kev
---(end of broadc
Dave Page wrote:
Kevin Field wrote:
One other detail, after it worked I noticed that the ID returned was one
where there had been a gap in the sequence (i.e., we had entries 1-12
and 14-24, and the new row had id 13.) This may be because the existing
entries had been added with explicit id numb
Kevin Field wrote:
> So this works fine in 1.6.3 (and psql), but in 1.8.0 beta's query window:
>
> The weird part is, it always returns the row right away like it should,
> but most times also keeps executing forever, until I press F5 again. To
> get it to stop, pressing repeatedly a few times se
Kevin Field написа:
> Hi,
>
> So I like the new hierarchy in 1.8.0, but it seems to be missing said
> categories of database objects. Is it planned for them to come back? I
> found I actually needed to use those two in particular yesterday and had
> to go back and use 1.6.3.
>
http://www.pgad
So this works fine in 1.6.3 (and psql), but in 1.8.0 beta's query window:
-- Executing query:
select now()
Total query runtime: 32 ms.
1 rows retrieved.
-- Executing query:
select now()::time
Total query runtime: 3766 ms.
1 rows retrieved.
-- Executing query:
select now()::time
Total query
