Is this the only way to add attributes to an existing table, and add
unique and a default(for example) to existing attributes?
Just wondered if there are alternatives. I didn't really see this in
the docs or mailing lists.
Thanks for any input.
Steve
original table:
CREATE TABLE table (
at
I saw that outer joins will be supported in ver. 7.1. Does anyone know
when this is expected, or if there is beta support for them currently?
Thanks,
Steve
Hello. Has anyone come across the above error? I've been trying to
create a database as user 'postgres', which doesn't report any errors,
but when I try to psql into it I get the above error about it having
disappeared from pg_database.
I'm not sure what might be wrong and hope someone might ha
bangh wrote:
> Hi steve,
>
> Your command should be like:
> iosdb=>drop sequence "classtable serials";
>
> Use the real name of the sequence, you cannot use serial to imply your sequence
> name. Your sequence seems having space. this is why you need to use the double
> quotation. Your can name y
bangh wrote:
> You mean a sequence? If so, under psql use command:\z to check the sequence
> name (it is stored in the table), then use the command drop sequence
> sequence_name
Thanks Banghe, here's what's there:
iosdb=> \z
Database= iosdb
+-+--+
| Rel
Can anyone tell me where this 'serials' relation is stored?
I had been getting a call handler error, which I was able to resolve by
clearing out pg_proc and I wondered if anyone could tell me how to clear
out the 'serials' relation.
Thanks,
Steve
standard debian jdk1.1 and postgres 6.5.3 packages.
I can't seem to find a lot of info on these errors as they might relate
to java.
Any help greatly appreciated!
Thanks,
Steve Doerr
