Klint Gore <[EMAIL PROTECTED]> writes:
> (Someone who knows more than I do might comment on what happens
> to unqualfied field names when the add missing from brings in another
> field with the same name?)
Nothing --- it's always been the case that unqualified field names have
to reference one of
I'm suprised it worked in 8.0. You should have got column reference is
ambiguous errors on seri_no since it appears in both dokuman and
onay_durum and there are 3 places where you don't specify which one you
want. (Someone who knows more than I do might comment on what happens
to unqualfied field
"Philip Ives" <[EMAIL PROTECTED]> writes:
> pg_get_serial_sequence doesn't return the correct sequence name and returns
> a null.
Can you provide a reproducible test case for this?
The example you give looks suspiciously like the column was not created
using the SERIAL notation, but through some
The following bug has been logged online:
Bug reference: 3295
Logged by: Philip Ives
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Darwin and FreeBSD 4
Description:pg_get_serial_sequence returns wrong sequence name for a
serial column
De
Todd Frankson wrote:
I have not Tried PSQL.
I use PG Admin.
Forgive me as i am not familiar with Postgres as much as other
databases.
I open the Query tool from PGAdmin
Type Select X from y
Where Z
I get back only a Portion of a field that is Defined as "text".
In the PGAdmin, the Max. Retur
On Mon, 21 May 2007, Max Khon wrote:
> Stephan Szabo wrote:
> > On Thu, 17 May 2007, Tom Lane wrote:
> >
> >> Max Khon <[EMAIL PROTECTED]> writes:
> >>> "delete from foo" fails:
> >>> ERROR: update or delete on table "bar" violates foreign key constraint
> >>> "foobar_fk0" on table "foobar"
> >>>
Todd Frankson wrote:
When selecting From a Text field that has 4096 characters in it, the query
tool only returns a few hundred characters, and exports maybe a hundred more
characters than the result set.
What happen if you do that in psql? Do you receive all data? And what
tool do you use -
Stephan Szabo wrote:
> On Thu, 17 May 2007, Tom Lane wrote:
>
>> Max Khon <[EMAIL PROTECTED]> writes:
>>> "delete from foo" fails:
>>> ERROR: update or delete on table "bar" violates foreign key constraint
>>> "foobar_fk0" on table "foobar"
>>> SQL state: 23503
>>> Detail: Key (bar_id)=(1) is stil
