i just downloaded packet2sql-2.0.3 and tried on my system.
i have postgresql 6.5.3 on a debian gnu/linux potato (frozen).
kernel 2.2.16 and postgres right set ok.
when i make psql eat src/logged_packets-ddl.sql it responds:
> NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
> 'logged_packets_pk' for table 'logged_packets'
> ERROR: Can't find a default operator class for type 1296.
anybody had the same problem?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2000-07-03
I've never received this error so I'll be guessing at the answer, but did you try to create the table as root? You have to create a database and run the ddl as a non-root user.
BTW, the NOTICE: you received is normal. The ERROR is not.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
nope, my rights are ok. i read about some index type matters around in
psql-hackers@something mailing list. i use postgresql 6.5.3.
which version you tested packets2sql with?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i just downloaded packet2sql-2.0.3 and tried on my system.
i have postgresql 6.5.3 on a debian gnu/linux potato (frozen).
kernel 2.2.16 and postgres right set ok.
when i make psql eat src/logged_packets-ddl.sql it responds:
> NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
> 'logged_packets_pk' for table 'logged_packets'
> ERROR: Can't find a default operator class for type 1296.
anybody had the same problem?
I've never received this error so I'll be guessing at the answer, but did you try to create the table as root? You have to create a database and run the ddl as a non-root user.
BTW, the NOTICE: you received is normal. The ERROR is not.
nope, my rights are ok. i read about some index type matters around in
psql-hackers@something mailing list. i use postgresql 6.5.3.
which version you tested packets2sql with?